SQL SERVER添加表注释、字段注释

对于一个已经创建好的表添加表的注释以及字段的注释，便于查看。

添加表注释

EXEC sys.sp_addextendedproperty 
@name=N'MS_Description', 
@value=N'表的描述信息' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'WebCrawler_TenderPrice'

@level1name是表名
@value是表的描述

修改表注释

EXEC sys.sp_updateextendedproperty 
@name=N'MS_Description', 
@value=N'表的描述信息修改' , 
@level0type=N'SCHEMA',
@level0name=N'dbo', 
@level1type=N'TABLE',
@level1name=N'WebCrawler_TenderPrice'

添加字段注释

EXEC sys.sp_addextendedproperty 
 @name=N'MS_Description', 
 @value=N'字段描述信息' , 
 @level0type=N'SCHEMA',
 @level0name=N'dbo', 
 @level1type=N'TABLE',
 @level1name=N'WebCrawler_TenderPrice',
 @level2type=N'COLUMN',
 @level2name=N'Category'

@value是字段描述信息
@level1name是表名
@level2name是列名

修改字段注释

EXEC sys.sp_updateextendedproperty 
 @name=N'MS_Description', 
 @value=N'字段描述信息修改' , 
 @level0type=N'SCHEMA',
 @level0name=N'dbo', 
 @level1type=N'TABLE',
 @level1name=N'WebCrawler_TenderPrice',
 @level2type=N'COLUMN',
 @level2name=N'Category'