进销存管理系统SQL+VB

use master go IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'进销存管理系统') DROP DATABASE [进销存管理系统] GO CREATE DATABASE [进销存管理系统] GO use [进销存管理系统] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_采购单表_供应商资料表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购单表] DROP CONSTRAINT FK_采购单表_供应商资料表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_盘点明细表_商品库存表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[盘点明细表] DROP CONSTRAINT FK_盘点明细表_商品库存表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_采购单明细表_商品资料表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购单明细表] DROP CONSTRAINT FK_采购单明细表_商品资料表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_商品库存表_商品资料表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[商品库存表] DROP CONSTRAINT FK_商品库存表_商品资料表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_销售单明细表_商品资料表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单明细表] DROP CONSTRAINT FK_销售单明细表_商品资料表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_销售单表_客户资料表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单表] DROP CONSTRAINT FK_销售单表_客户资料表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_采购单明细表_采购单表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[采购单明细表] DROP CONSTRAINT FK_采购单明细表_采购单表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_销售单明细表_销售单表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[销售单明细表] DROP CONSTRAINT FK_销售单明细表_销售单表 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商资料表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商资料表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[商品库存表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[商品库存表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[商品资料表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[商品资料表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[客户资料表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[客户资料表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[盘点明细表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[盘点明细表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购单明细表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[采购单明细表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[采购单表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[采购单表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单明细表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[销售单明细表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售单表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[销售单表] GO CREATE TABLE [dbo].[供应商资料表] ( [供应商编号] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL , [供应商名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [地址] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [电话] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [传真] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [信誉等级] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [提供商品] [text] COLLATE Chinese_PRC_CI_AS NULL , [简介] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[商品库存表] ( [商品编号] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [商品状态] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [成本价] [flo�