代码改变世界

SQL 2005中取出字段的备注信息

2010-06-09 17:28  飞逝心情  阅读(183)  评论(0)  编辑  收藏  举报 
select 
a.name,
type_name(system_type_id) as datatype,
b.value as description
from sys.Columns as a,sys.extended_properties as b
where b.major_id=a.object_id and a.column_id=b.minor_id 
and a.object_id in
  (select object_id from sys.tables where name='Message')