【文章內(nèi)容簡(jiǎn)介】 INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。PAYL_RECORD39。) AND NAME = 39。PAYL_RECORD_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。PAYL_RECORD39。) AND TYPE = 39。U39。) DROP TABLE PAYL_RECORDGOIF EXISTS (SELECT 1 FROM SYSINDEXES27 / 55 WHERE ID = OBJECT_ID(39。RECEIPT39。) AND NAME = 39。開具_(dá)FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。RECEIPT39。) AND TYPE = 39。U39。) DROP TABLE RECEIPTGOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。RECEIPT_RE39。) AND NAME = 39。RECEIPT_RE2_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSINDEXES28 / 55 WHERE ID = OBJECT_ID(39。RECEIPT_RE39。) AND NAME = 39。RECEIPT_RE_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。RECEIPT_RE39。) AND TYPE = 39。U39。) DROP TABLE RECEIPT_REGOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。SELL_BILL39。) AND NAME = 39。出示 1_FK39。 AND INDID 0 AND INDID 255) DROP INDEX 1_FKGOIF EXISTS (SELECT 1 FROM SYSOBJECTS29 / 55 WHERE ID = OBJECT_ID(39。SELL_BILL39。) AND TYPE = 39。U39。) DROP TABLE SELL_BILLGOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。SELL_RECORD39。) AND NAME = 39。SELL_RECORD3_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。SELL_RECORD39。) AND NAME = 39。SELL_RECORD2_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSINDEXES30 / 55 WHERE ID = OBJECT_ID(39。SELL_RECORD39。) AND NAME = 39。SELL_RECORD_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。SELL_RECORD39。) AND TYPE = 39。U39。) DROP TABLE SELL_RECORDGOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。STAFF39。) AND TYPE = 39。U39。) DROP TABLE STAFFGOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。WAREHOUSE_GOODS39。) AND TYPE = 39。U39。)31 / 55 DROP TABLE WAREHOUSE_GOODSGOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。采購(gòu)記錄39。) AND NAME = 39。采購(gòu)記錄 2_FK39。 AND INDID 0 AND INDID 255) DROP INDEX 2_FKGOIF EXISTS (SELECT 1 FROM SYSINDEXES WHERE ID = OBJECT_ID(39。采購(gòu)記錄39。) AND NAME = 39。采購(gòu)記錄_FK39。 AND INDID 0 AND INDID 255) DROP INDEX GOIF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID(39。采購(gòu)記錄39。)32 / 55 AND TYPE = 39。U39。) DROP TABLE 采購(gòu)記錄GO/*==============================================================*//* TABLE: BUY_BILL *//*==============================================================*/CREATE TABLE BUY_BILL ( BBNO CHAR(10) NOT NULL, SNO CHAR(10) NULL, BBDATE DATETIME NULL, CONSTRAINT PK_BUY_BILL PRIMARY KEY NONCLUSTERED (BBNO))GO/*==============================================================*//* INDEX: 制定 2_FK *//*==============================================================*/CREATE INDEX 制定 2_FK ON BUY_BILL (SNO ASC)GO33 / 55/*==============================================================*//* TABLE: BUY_PLAN *//*==============================================================*/CREATE TABLE BUY_PLAN ( BPNO CHAR(10) NOT NULL, SNO CHAR(10) NULL, BPDATE DATETIME NULL, CONSTRAINT PK_BUY_PLAN PRIMARY KEY NONCLUSTERED (BPNO))GO/*==============================================================*//* INDEX: 制定 1_FK *//*==============================================================*/CREATE INDEX 制定 1_FK ON BUY_PLAN (SNO ASC)GO/*==============================================================*/34 / 55/* TABLE: OUT_REC *//*==============================================================*/CREATE TABLE OUT_REC ( BPNO CHAR(10) NOT NULL, WGNO