如何取得sqlserver表的字段的描述?

rt
---------------------------------------------------------------

SELECT o.name as tableName,c.name as columnName,p.value as Description
FROM sysproperties p
join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid
where p.name='MS_Description'
order by 1

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus