如何删除表字段描述?
CREATE table T1 (id int , name char (20))
增加表字段描述:
EXEC sp_addextendedproperty 'caption ', 'Employee ID ', 'user ', dbo, 'table ', 'T1 ', 'column ', id
更改表字段描述:
EXEC sp_updateextendedproperty 'caption ', 'Employee 1 ID ', 'user ', dbo, 'table ', 'T1 ', 'column ', id
查看表字段描述:
SELECT * FROM ::fn_listextendedproperty (NULL, 'user ', 'dbo ', 'table ', 'T1 ', 'column ', default)
?如何删除表字段描述呢 ?
------解决方案--------------------sp_dropextendedproperty
------解决方案----------------------參考
http://www.orientaloutlook.com/servlet/Report?Node=45622&Language=1
------解决方案--------------------sp_dropextendedproperty