查询数据库所有(某个)表中字段名,数据类型,说明等

 

 

--查询数据库所有

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

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。