use 指定数据库名称
go
select 字段名 =a.name,
类型 = B.name,
字段说明 =isnull(g.[value],'')
from
syscolumns a
Left Join
systypes B
On
A.xusertype=B.xusertype
left join
sys.extended_properties g
on
a.id=g.major_id and a.colid=g.minor_id
where id=(select max(id) from sysobjects where xtype='u' and name='指定表名称')