summaryrefslogtreecommitdiff
path: root/sql/DB2-remove.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/DB2-remove.sql')
-rwxr-xr-xsql/DB2-remove.sql47
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/DB2-remove.sql b/sql/DB2-remove.sql
new file mode 100755
index 00000000..413bebb2
--- /dev/null
+++ b/sql/DB2-remove.sql
@@ -0,0 +1,47 @@
+-- DB2-remove.sql
+--
+--
+-- Jim Rawlings modified for use with SL 2.0.8 and DB2 v7.2
+-- and higher August 27, 2003
+--
+--
+---------------------------------------------------------
+-- DDL Statements for object removal
+---------------------------------------------------------
+DROP TRIGGER partsgroupid;
+DROP TRIGGER projectid;
+DROP TRIGGER employeeid;
+DROP TRIGGER oeid;
+DROP TRIGGER apid;
+DROP TRIGGER arid;
+DROP TRIGGER partsid;
+DROP TRIGGER customerid;
+DROP TRIGGER vendorid;
+DROP TRIGGER invoiceid;
+DROP TRIGGER chartid;
+DROP TRIGGER glid;
+DROP SEQUENCE id RESTRICT;
+DROP TABLE partsgroup;
+DROP TABLE project;
+DROP TABLE shipto;
+DROP TABLE employee;
+DROP TABLE exchangerate;
+DROP TABLE orderitems;
+DROP TABLE oe;
+DROP TABLE vendortax;
+DROP TABLE customertax;
+DROP TABLE tax;
+DROP TABLE partstax;
+DROP TABLE ap;
+DROP TABLE ar;
+DROP TABLE assembly;
+DROP TABLE parts;
+DROP TABLE customer;
+DROP TABLE vendor;
+DROP TABLE invoice;
+DROP TABLE acc_trans;
+DROP TABLE defaults;
+DROP TABLE gifi;
+DROP TABLE chart;
+DROP TABLE gl;
+DROP TABLE makemodel;