1、添加表说明
语法:EXEC sp_addextendedproperty N'MS_Description', @value=N'字段说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名'
实例:EXEC sp_addextendedproperty N'MS_Description', @value=N'XML查询' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'XmlQuery'
2、更新表说明
语法:EXEC sp_updateextendedproperty N'MS_Description', @value=N'字段说明',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名'
实例:EXEC sp_updateextendedproperty N'MS_Description', @value=N'XML查询' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'XmlQuery'
3、删除表说明
语法:EXEC sp_dropextendedproperty N'MS_Description',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名'
实例:EXEC sp_dropextendedproperty N'MS_Description', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'XmlQuery'
4、添加表字段说明
语法:EXEC sp_addextendedproperty 'MS_Description', @value=N'字段说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名', @level2type=N'COLUMN', @level2name=N'字段名'
实例:EXEC sp_addextendedproperty 'MS_Description', @value=N'是否为大额签报(0:否;1:是)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Quota_Report', @level2type=N'COLUMN', @level2name=N'IsMaxReport'
5、更新表字段说明
语法:EXEC sp_updateextendedproperty 'MS_Description',@value=N'字段说明',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名', @level2type=N'COLUMN', @level2name=N'字段名'
实例:EXEC sp_updateextendedproperty 'MS_Description', @value=N'是否为大额签报(0:否;1:是)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Quota_Report', @level2type=N'COLUMN', @level2name=N'IsMaxReport'
6、删除表字段说明
语法:EXEC sp_dropextendedproperty 'MS_Description',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'表名', @level2type=N'COLUMN', @level2name=N'字段名'
实例:EXEC sp_dropextendedproperty 'MS_Description',@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'XmlQuery', @level2type=N'COLUMN', @level2name=N'Name'