diff options
author | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
---|---|---|
committer | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
commit | 5fc8c5edf574ab024d4646914b6432d458e2ffbd (patch) | |
tree | c8031ae966b35c47f6aea9929e10911412ff6c59 /sql-ledger/sql/DB2-remove.sql | |
parent | a4fc489e860b7bc51b5282a87ea21750b30b905e (diff) | |
parent | 32306b5f8ffe4ce594409aa6e89626740b225a39 (diff) |
This commit was generated by cvs2svn to compensate for changes in r3883,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'sql-ledger/sql/DB2-remove.sql')
-rw-r--r-- | sql-ledger/sql/DB2-remove.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql-ledger/sql/DB2-remove.sql b/sql-ledger/sql/DB2-remove.sql new file mode 100644 index 000000000..413bebb2d --- /dev/null +++ b/sql-ledger/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; |