Mike's Developer Notes
Friday, April 10, 2015
How to Drop All User Tables in Oracle
Problem
You want to remove/drop all user tables from on Oracle Database.
Solution
1. Run the following SQL query
select 'drop table '||table_name||' cascade constraints;' from user_tables;
2. Run the SQL query generated after the 1st step above.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment