SQL2005表结构一览SQL文

SELECT  *
FROM    syscolumns
WHERE   id = OBJECT_ID('fs_ads_stat')
ORDER BY colorder ASC

SELECT 
  --A.id,
        表名 = D.NAME ,
  --表名 = 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 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