-- This script will create a SQL script to remove any tables in the current schema.
-- Mark Reineck 12-22-1997

set feedback off
set head off
set echo off

-- Write the script to a file, otherwise it is useless

spool deltbls.sql

-- Create the table creation sql statements

select 'drop table '||table_name||';' from user_tables ;

spool off;

-- Reset some stuff

set feedback on
set head on
set echo on