Return to Snippet

Revision: 16487
at August 6, 2009 06:00 by kamilch


Updated Code
-- drop all tables in current schema
declare
   table_name varchar2(30);
   cursor usertables is select * from user_tables where table_name not like 'BIN$%';
begin
   for next_row in usertables
   loop
      execute immediate 'drop table ' || next_row.table_name || ' cascade constraints';
   end loop;
end;
/

Revision: 16486
at August 6, 2009 05:56 by kamilch


Initial Code
-- drop all tables in current schema
declare
   table_name varchar2(30);
   cursor usertables is select * from user_tables where table_name not like 'BIN$%';
begin
   for next_row in usertables
   loop
      execute immediate 'drop table ' || next_row.table_name || ' cascade constraints';
   end loop;
end;
/

Initial URL

                                

Initial Description

                                

Initial Title
Drop all tables in Oracle

Initial Tags
Oracle

Initial Language
PL/SQL