紫昀-成长ING

生我何用、不能狂笑,灭我何用、不减狂骄。
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

T-SQL2005 添加、删除表及表字段说明

Posted on 2010-02-25 09:47  紫昀-成长ING  阅读(3055)  评论(0)    收藏  举报

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'