SELECT
\u8868\u540d = Case When A.colorder=1 Then D.name Else ” End,
\u8868\u8bf4\u660e = Case When A.colorder=1 Then isnull(F.value,”) Else ” End,
\u5b57\u6bb5\u5e8f\u53f7 = A.colorder,
\u5b57\u6bb5\u540d = A.name,
\u5b57\u6bb5\u8bf4\u660e = isnull(G.[value],”),
\u6807\u8bc6 = Case When COLUMNPROPERTY( A.id,A.name,’IsIdentity’)=1 Then ‘\u221a’ Else ” End,
\u4e3b\u952e = Case When exists(SELECT 1 FROM sysobjects Where xtype=’PK’ and parent_obj=A.id and name in (
SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = A.id AND colid=A.colid))) then ‘\u221a’ else ” end,
\u7c7b\u578b = B.name,
–\u5360\u7528\u5b57\u8282\u6570 = A.Length,
\u957f\u5ea6 = COLUMNPROPERTY(A.id,A.name,’PRECISION’),
\u5c0f\u6570\u4f4d\u6570 = isnull(COLUMNPROPERTY(A.id,A.name,’Scale’),0),
\u5141\u8bb8\u7a7a = Case When A.isnullable=1 Then ‘\u221a’Else ” End,
\u9ed8\u8ba4\u503c = isnull(E.Text,”)
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
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<\/p>\n
sys.extended_properties F
On
D.id=F.major_id and F.minor_id=0
where d.name=’tableName’ –\u5982\u679c\u53ea\u67e5\u8be2\u6307\u5b9a\u8868,\u52a0\u4e0a\u6b64\u6761\u4ef6
Order By
A.id,A.colorder<\/p>\n
<\/p>\n
–\u83b7\u53d6\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u8868\u7684\u540d\u79f0\u3001\u4e00\u4e2a\u8868\u4e2d\u6240\u6709\u5b57\u6bb5\u7684\u540d\u79f0<\/strong><\/p>\n SELECT (case when a.colorder=1 then d.name else null end) \u8868\u540d, <\/p>\n","protected":false},"excerpt":{"rendered":" SELECT\u8868\u540d = Case When A.colorder=1 Then D.name Else ” End,\u8868\u8bf4\u660e = Case When A.colorder=1 Then isnull(F.value,”) Else ” End,\u5b57\u6bb5\u5e8f\u53f7 = A.colorder,\u5b57\u6bb5\u540d = A.name,\u5b57\u6bb5\u8bf4\u660e = isnull(G.[value],”),\u6807\u8bc6 = Case When COLUMNPROPERTY( A.id,A.name,’IsIdentity’)=1 Then ‘\u221a’ Else ” End,\u4e3b\u952e = Case When exists(SELECT 1 FROM sysobjects Where xtype=’PK’ and parent_obj=A.id and name in (SELECT name FROM sysindexes WHERE indid […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-20","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/20","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/20\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
a.colorder \u5b57\u6bb5\u5e8f\u53f7,a.name \u5b57\u6bb5\u540d,
(case when COLUMNPROPERTY( a.id,a.name,’IsIdentity’)=1 then ‘\u221a’else ” end) \u6807\u8bc6,
(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 ‘\u221a’ else ” end) \u4e3b\u952e,b.name \u7c7b\u578b,a.length \u5360\u7528\u5b57\u8282\u6570,
COLUMNPROPERTY(a.id,a.name,’PRECISION’) as \u957f\u5ea6,
isnull(COLUMNPROPERTY(a.id,a.name,’Scale’),0) as \u5c0f\u6570\u4f4d\u6570,(case when a.isnullable=1 then ‘\u221a’else ” end) \u5141\u8bb8\u7a7a,
isnull(e.text,”) \u9ed8\u8ba4\u503c,isnull(g.[value], ‘ ‘) AS [\u8bf4\u660e]
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
and d.name=’tableName’ –\u5982\u679c\u53ea\u67e5\u8be2\u6307\u5b9a\u8868,\u52a0\u4e0a\u6b64\u6761\u4ef6
order by a.id,a.colorder<\/p>\n