Public snipts » Fotinakis's snipts » Drop all tables, constraints, and sequences within an Oracle schema

• BEGIN
  
  FOR c IN (SELECT table_name FROM user_tables) LOOP
  EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
  END LOOP;
  
  FOR s IN (SELECT sequence_name FROM user_sequences) LOOP
  EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);
  END LOOP;
  
  END;

  sql

  1

  BEGIN
  
  FOR c IN (SELECT table_name FROM user_tables) LOOP
  EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
  END LOOP;
  
  FOR s IN (SELECT sequence_name FROM user_sequences) LOOP
  EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);
  END LOOP;
  
  END;
  

  copy | embed

0 Comments