Oracle DB:
Approach1:
select 'Drop table MY_SCHEMA.' || TABLE_NAME || ';'
from ALL_TABLES where OWNER = 'MY_SCHEMA';
Approach1:
select 'Drop table MY_SCHEMA.' || TABLE_NAME || ';'
from ALL_TABLES where OWNER = 'MY_SCHEMA';
Approach2:
<TO_DO>
No comments:
Post a Comment