Showing posts with label sql oracle. Show all posts
Showing posts with label sql oracle. Show all posts

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>