数据库课程设计-物资管理系统设计

le [dbo].[msave]РGOРif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[msurplus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)Рdrop table [dbo].[msurplus]РGOРif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[muse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)Рdrop table [dbo].[muse]РGOРCREATE 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]РGOРCREATE TABLE [dbo].[msave] (Р?[rkno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,Р?[rkid] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,