Monday, November 7, 2011

How to remove all table from schema

Oracle DB:

Approach1:
select 'Drop table MY_SCHEMA.' ||  TABLE_NAME || ';'
from ALL_TABLES where OWNER = 'MY_SCHEMA';

Approach2:
<TO_DO>

No comments:

Post a Comment