use 指定数据库名称
go
SELECT
表名 = D.name ,
字段序号 = A.colorder,
字段名 = A.name,
类型 = B.name,
字段说明=isnull(g.[value],'')
FROM
syscolumns A
Left Join
systypes B
On
A.xusertype=B.xusertype
Inner Join
sysobjects D
On
A.id=D.id and D.xtype='U' and D.name<>'dtproperties'
left join
sys.extended_properties g
on a.id=g.major_id and a.colid=g.minor_id
where A.name= '指定字段名称'