——直接放在需要查詢的庫中執行即可。
SELECT (
case
when a.colorder=
1
then d.name
else
null
end) 表名,
a.colorder 字段序號,a.name 字段名,
(
case
when COLUMNPROPERTY( a.id,a.name,
'
IsIdentity
'
)=
1
then
'
√
'
else
''
end) 標識,
(
case
when (SELECT count(*
) FROM sysobjects
WHERE (name
in
(SELECT name FROM sysindexes
WHERE (id
= a.id) AND (indid
in
(SELECT indid FROM sysindexkeys
WHERE (id
= a.id) AND (colid
in
(SELECT colid FROM syscolumns WHERE (id
= a.id) AND (name =
a.name)))))))
AND (xtype
=
'
PK
'
))>
0
then
'
√
'
else
''
end) 主鍵,b.name 類型,a.length 占用字節數,
COLUMNPROPERTY(a.id,a.name,
'
PRECISION
'
)
as
長度,
isnull(COLUMNPROPERTY(a.id,a.name,
'
Scale
'
),
0
)
as
小數位數,(
case
when a.isnullable=
1
then
'
√
'
else
''
end) 允許空,
isnull(e.text,
''
) 默認值,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
--WHERE d.name=
'
要查詢的表
'
--
如果只查詢指定表,加上此條件
order by a.id,a.colorder
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
