Last Updated: February 25, 2016
·
488
· mitemitreski

Generate drop table command for user schema PL/SQL

The following will generate a drop table for each of the user tables:

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