sqlserver 如何带字段注释说明的sql语句

create table patient(
id int primary key,
name nvarchar(20),
sex nvarchar(2),
birthday datetime,
sidno nvarchar(20),
sidtype tinyint,
celladdress nvarchar(100),
cellphone nvarchar(15),
homeaddress nvarchar(100),
homephone nvarchar(15),
companynameaddress nvarchar(100),
companyphone nvarchar(20),
e_mail nvarchar(50),
firstman nvarchar(20),
firstquery nvarchar(20),
firstphone nvarchar(15),
firstaddress nvarchar(100),
recorddate datetime,
cardtype tinyint,
balance decimal(10,2),
creditlimit decimal(10,
own_by int,
create_by int,
create_on date,
update_by int,
update_on int
)
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'id',@level0type=N'SCHEMA',
@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'patient',@level2type=N'COLUMN',
@level2name=N'id'
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'病人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'celladdress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'境外电话',
@level2name=N'cellphone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'家庭地址',
@level2name=N'homeaddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'家庭电话',
@level2name=N'homephone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'公司名称及地址',
@level2name=N'companynameaddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'公司电话',
@level2name=N'companyphone'
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'firstman'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'紧急联系人关系',
@level2name=N'firstquery'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'紧急联系人电话',
@level2name=N'firstphone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'紧急联系人地址',
@level2name=N'firstaddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',
@level2name=N'recorddate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'卡类型',
@level2name=N'cardtype'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'余额',
@level2name=N'balance'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'拥有者',
@level2name=N'creditlimit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'创建者',
@level2name=N'create_by'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'创建时间',
@level2name=N'create_on'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'更新者',
@level2name=N'update_by'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@value=N'更新时间',

@level2name=N'update_on'

（编辑：李大同）

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