sqlserver添加查询 表、字段注释（转）

环境:xp sp3,sql server2008

1、sqlserver用语句给表注释
EXECUTE sp_addextendedproperty N'MS_Description',N'表注释',N'user',N'dbo',N'table',N'表名',NULL,NULL

2、sqlserver用语句给表的“字段”注释
EXECUTE sp_addextendedproperty N'MS_Description',N'字段注释',N'表名',N'column',N'字段名'

3、查看sqlserver注释

SELECT
A.name AS table_name,
B.name AS column_name,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = '表名'

转自：http://begoodluck.blog.163.com/blog/static/20450728020141191412788/

（编辑：李大同）

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