数据库.sql

来自「企业客户管理信息系统 企业管理信息系统的对象是企业、企业化管理的事业单位。 客」· SQL 代码 · 共 65 行

use master
go

if exists (select * from dbo.sysdatabases where name = 'Trade') 
drop database Trade
GO

create database Trade
go
use Trade
go


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[suppliers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[suppliers]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kk_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kk_Info]
GO

CREATE TABLE [dbo].[suppliers] (
	[SupplierID] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CompanyName] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ContactName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Region] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostalCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SupplierMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[kk] (
	[SupplierID] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CompanyName] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ContactName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Region] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostalCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SupplierMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[user_Info] (
	[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
) ON [PRIMARY]
GO

use Trade
INSERT INTO user_info
VALUES (1,1);