查询数据库所有（某个）表中字段名，数据类型，说明等
--查询数据库所有
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
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
