diff options
Diffstat (limited to 'sql/DB2-remove.sql')
-rwxr-xr-x | sql/DB2-remove.sql | 47 |
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; |