【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-Customer.sql,希望本篇文章对您学习有所帮助。
USE Mis
GO
CREATE TABLE [Customer] (
[CustId] [int] IDENTITY (1, 1) NOT NULL ,
[CustName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CustTypeId] [int] NOT NULL ,
[Address] [varchar] (400) COLLATE Chinese_PRC_CI_AS NULL ,
[Postcode] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[AreaId] [int] NOT NULL ,
[BussTypeId] [int] NULL ,
[EmpId] [int] NULL ,
CONSTRAINT [PK__CltOrg__73BA3083] PRIMARY KEY CLUSTERED
(
[CustId]
) ON [PRIMARY]
) ON [PRIMARY]
GO