--查询数据库所有

SELECT (case when a.colorder=1 then d.name else null end) 表名,
a.colorder 字段序号,a.name 字段名,
isnull(g.[value], ‘ ‘) AS [说明]
FROM syscolumns a
left join systypes b on a.xtype=b.xusertype
inner join sysobjects d on a.id=d.id and d.xtype=‘U‘ and d.name<>‘dtproperties‘
left join syscomments e on a.cdefault=e.id
left join sys.extended_properties g on a.id=g.major_id AND a.colid=g.minor_id
left join sys.extended_properties f on d.id=f.class and f.minor_id=0
where b.name is not null
order by a.id,a.colorder

--查询某个表
SELECT a.name as FieldCode,‘T_EXEntryHead‘ TableName,isnull(g.[value], ‘ ‘) FieldName FROM syscolumns a
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 d.name = ‘T_EXEntryHead‘ --表名

order by a.id,a.colorder

查询数据库所有（某个）表中字段名，数据类型，说明等