【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-Contact.sql,希望本篇文章对您学习有所帮助。
USE Mis
GO
CREATE TABLE [Contact] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[CustId] [int] NOT NULL ,
[CName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Sex] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[TitleId] [int] NULL ,
[Office] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Mobile] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Level] [tinyint] NULL ,
[Hobby] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Memo] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK__Contact__778AC167] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO