Saturday, 8 December 2012

Drop all tables for a specified user in Oracle

Begin
for a in (select table_name from user_tables) loop
execute immediate ('drop table '||a.table_name||' cascade constraints');
end loop;
End;

No comments:

Post a Comment