Advanced Search

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