单表操作方法:
select 'exec sp_addextendedproperty N''MS_Description'', N'''+cast(value as varchar)+''',N''user'', N''dbo'', N''table'', N'''+object_name(b.id)+''',N''column'', N'''+a.name+''''
from syscolumns a inner join sysproperties b on a.id=b.id and a.colid=b.smallid and object_name(b.id)='表名
多表操作方法:
select 'exec sp_addextendedproperty N''MS_Description'', N'''+cast(value as varchar)+''',N''user'', N''dbo'', N''table'', N'''+object_name(b.id)+''',N''column'', N'''+a.name+''''
from syscolumns a inner join sysproperties b on a.id=b.id and a.colid=b.smallid
执行以上语句将结果拷到SQL查询分析器中执行就将说明附加上来了。