日期:2014-05-19  浏览次数:20494 次

高手帮我!为表字段添加注释的sql语句怎么写??
为A表的列col   添加   注释Remark    
用语句怎么实现?

------解决方案--------------------
试一下
exec sp_addextendedproperty
N 'MS_Description ', N '注释Remark,
N 'user ', N 'dbo ',
N 'table ', N 'A表 ',
N 'column ', N '列col '

------解决方案--------------------
EXEC sp_addextendedproperty
@name = N '注释 ', @value = '这是注释值remark ',
@level0type = N 'Schema ', @level0name = dbo,
@level1type = N 'Table ', @level1name = a,
@level2type = N 'Column ', @level2name = col;