Public snipts » Fotinakis's snipts » Drop all tables and constraints 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;
  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;
  END;
  

  copy | embed

0 Comments