Re: How to DROP ALL TABLEs?

Try this script

set pagesize 0
set heading off
set feedback off
spool droptab.sql
select 'drop',table_name,';' from cat where table_type='TABLE'; spool off
@droptab.sql Received on Mon May 18 1998 - 00:00:00 CDT