SQL 2005中取出字段的备注信息
2010-06-09 17:28 飞逝心情 阅读(182) 评论(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')