blob: 413bebb2da0b77eab5262abf721ad28d1dba85c3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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;
|
