SqlServer创建数据表



create table employee(
 id int primary key  IDENTITY(1,1) NOT NULL,
 no nvarchar(20),
 name nvarchar(20) ,
 password nvarchar(50) ,
 sex nvarchar(2),
 birthday datetime,
 sidno nvarchar(20),
 sidtype tinyint,
 address nvarchar(100),
 phone nvarchar(15),
 e_mail nvarchar(50),
 own_by int,
 created_by int,
 created_on datetime,
 updated_by int,
 updated_on datetime
 )
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'id' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'id'
  GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'no'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'name'
  GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'password'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'病人id' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'sex'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生年月' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'birthday'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件编号' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'sidno'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'证件类型' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'sidtype'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'address'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'phone'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'e_mail'
  GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'拥有者' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'own_by'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'created_by'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'created_on'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新者' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',
 @level2name=N'updated_by'
 GO
 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'SCHEMA',
 @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'operator', @level2type=N'COLUMN',

@level2name=N'updated_on'