MSSQL，查询用户表字段(主键及标识)

                Select
                C.name As TableName,
                C.id As TableObjectId,
                A.name As ColumnName,
                A.colid As ColumnObjectId,
                A.[length] As ColumnLength,
                B.name As ColumnDataType,
                ISNULL(D.[text],'') AS DefaultValue,
                ISNULL(E.name,'') As PropertyName,
                ISNULL(E.value,'') As PropertyValue,
                COLUMNPROPERTY(A.id,A.name, 'AllowsNULL') AS AllowsNull,
                COLUMNPROPERTY(A.id,A.name, 'IsCursorType') AS IsCursorType,
                COLUMNPROPERTY(A.id,A.name, 'IsIdentity') AS IsIdentity,
                (Select Count(1) From
                sysobjects
                INNER JOIN sysindexes ON sysobjects.parent_obj=sysindexes.id AND sysobjects.name=sysindexes.name
                INNER JOIN sysindexkeys ON sysindexes.id=sysindexkeys.id AND sysindexes.indid=sysindexkeys.indid 
                Where sysobjects.xtype='PK' AND sysobjects.parent_obj=A.id AND sysindexkeys.colid=A.colid) AS IsPrimaryKey
                From
             dbo.syscolumns A
             INNER JOIN dbo.systypes B ON B.xusertype=A.xtype
             INNER JOIN dbo.sysobjects C ON C.id=A.id AND C.xtype='U' AND C.name not in ('dtproperties','sysdiagrams')
             LEFT JOIN dbo.syscomments D ON A.cdefault = D.id
             LEFT JOIN sys.extended_properties E ON E.major_id=A.id AND E.minor_id=A.colid order by A.colid