SQLÓï¾ä£º²éѯÊý¾Ý¿âÖÐËùÓзÇϵͳ±íµÄÐÅÏ¢

SELECT
       (case when a.colorder=1 then d.name else '' 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
                                  WH