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'编号',
?@level2name=N'no'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'姓名',
?@level2name=N'name'
? GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'密码',
?@level2name=N'password'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'病人id',
?@level2name=N'sex'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'出生年月',
?@level2name=N'birthday'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'证件编号',
?@level2name=N'sidno'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'证件类型',
?@level2name=N'sidtype'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'地址',
?@level2name=N'address'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'电话',
?@level2name=N'phone'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'邮箱',
?@level2name=N'e_mail'
? GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'拥有者',
?@level2name=N'own_by'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'创建者',
?@level2name=N'created_by'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'创建时间',
?@level2name=N'created_on'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'更新者',
?@level2name=N'updated_by'
?GO
?EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'更新时间',

@level2name=N'updated_on'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!