SQL SERVER 2005 »ñÈ¡±í½á¹¹ÐÅÏ¢

SELECT ±íÃû   = CASE a.colorder WHEN 1 THEN c.name ELSE '' END,
       Ðò     = a.colorder,
       ×Ö¶ÎÃû = a.name,
       ±êʶ   = CASE COLUMNPROPERTY(a.id,a.name,'IsIdentity') WHEN 1 THEN '√' ELSE '' END,
       Ö÷¼ü   = CASE
  WHEN EXISTS ( SELECT *
                  from sysobjects
                 WHERE xtype='PK'
                   AND name IN (SELECT [name]
                                  from sysindexes
                                 WHERE id=a.id
                                   AND indid IN (SELECT indid
                                                   from sysindexkeys
                                 &nbs