IntegrationTest/sql/destroy_db.sql

0001 /* Utterly annihilate a DB */
0002
0003 BEGIN
0004   FOR result IN (SELECT table_name FROM user_tables)
0005   LOOP
0006     EXECUTE IMMEDIATE 'DROP TABLE ' || result.table_name || ' CASCADE CONSTRAINTS';
0007   END LOOP;
0008 END;
0009 /
0010
0011 BEGIN
0012   FOR result IN (SELECT sequence_name FROM user_sequences)
0013   LOOP
0014     EXECUTE IMMEDIATE 'DROP SEQUENCE ' || result.sequence_name;
0015   END LOOP;
0016 END;
0017 /
0018
0019 BEGIN
0020   FOR result IN (SELECT object_name FROM user_procedures)
0021   LOOP
0022     EXECUTE IMMEDIATE 'DROP PROCEDURE ' || result.object_name;
0023   END LOOP;
0024 END;
0025 /
0026
0027
0028 BEGIN
0029   FOR result IN (SELECT object_name AS FUNCTION FROM user_objects WHERE object_type = 'FUNCTION')
0030   LOOP
0031     EXECUTE IMMEDIATE 'DROP FUNCTION ' || result.function;
0032   END LOOP;
0033 END;
0034 /
0035
0036
0037 BEGIN
0038   FOR result IN (SELECT trigger_name, table_name FROM user_triggers WHERE trigger_name NOT LIKE 'BIN%')
0039   LOOP
0040     EXECUTE IMMEDIATE 'DROP TRIGGER ' || result.trigger_name;
0041   END LOOP;
0042 END;
0043 /
0044
0045
0046 BEGIN
0047   FOR result IN (SELECT db_link, username FROM user_db_links)
0048   LOOP
0049     EXECUTE IMMEDIATE 'DROP DATABASE LINK ' || result.db_link;
0050   END LOOP;
0051 END;
0052 /