數(shù)據(jù)庫(kù)課程設(shè)計(jì)-物資管理系統(tǒng)設(shè)計(jì)-在線瀏覽
2024-09-17 22:26本頁(yè)面
【正文】 if exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[msave]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[msurplus]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[muse]GOCREATE TABLE [dbo].[material] ( [wzid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzspec] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [wzkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [wzunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[msave] ( [rkno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [rkspec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [rkkind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkunit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkaccount] [numeric](5, 0) NOT NULL , [rkprice] [numeric](8, 2) NOT NULL , [rkvalue] [numeric](10, 2) NOT NULL , [rkdate] [datetime] NOT NULL , [rkdeal_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [rksave_person] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [rkbase] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [rkmemo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOCREATE TABLE [dbo].[msurplus] ( [yeid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [yename] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [yespec] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [yekind] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [yeunit] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yeaccount] [numeric](5, 0) NOT NULL , [yevalue] [numeric](10, 2) NOT NULL , [yebase] [char] (10) COLLATE Chinese_PRC_CI_AS NOT
物理相關(guān)推薦
鄂ICP備17016276號(hào)-1