对于一个已经创建好的表添加表的注释以及字段的注释,便于查看。
添加表注释
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'