Below SQL select statement create list of SQLs to delete all tables
For ORACLE schema
SELECT 'DROP TABLE "' || TABLE_NAME ||
'" CASCADE
CONSTRAINTS;' FROM user_tables;
For MSSQL schema
use [database_name]
SELECT 'DROP TABLE {user}.'
Where {user} is the owning user of the tables.
SELECT 'DROP TABLE {user}
Where {user} is the owning user of the tables.
(drop all tables of database)
Comments