Dear SQL experts,

I want to use Query Analyser to drop my tables.

I need only to drop tables in one particular company.

I tried 'DROP TABLE %333' but it gives errors.

Can some one give me the command to do so.

Thanks and regards,

Hello anyone out there,

Any suggestion to my above problem.

regards

here's how to do it in oracle.

you can't use wildcards with commands, only queries.

spool droptab.sql
select 'drop table '||table_name||';' from dba_tables
where owner = 'BAAN' -- (or 'BAANDB' if that's what you use..)
and table_name like '%333';
spool off