高手帮我!为表字段添加注释的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;