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;
Written by Mite Mitreski
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Sql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#