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