获取SQLSERVER一张表里面的常用字段信息

概述SELECTTableName=d.name,--表名称FieldNo=a.colorder,--字段编号FieldName=a.name,--字段名称IsIdentity=case when COLUMNPROPERTY(a.id,a.name,'IsIdentity')=1 then 'true'else 'false' end,--是否自增PrimaryKey=case

SELECTtablename=d.name,--表名称FIEldNo=a.colorder,--字段编号FIEldname=a.name,--字段名称IsIDentity=case when ColUMNPROPERTY(a.ID,a.name,'IsIDentity')=1 then 'true'else 'false' end,--是否自增PrimaryKey=case when exists(     SELECT 1 FROM sysobjects where xtype='PK' and name in     (         SELECT name FROM sysindexes WHERE indID in         (              SELECT   indID   FROM   sysindexkeys   WHERE   ID   =   a.ID   AND   colID=a.colID         )     ))then 'true' else 'false' end,--是否主键FIEldType=b.name,--字段类型FIEldLength=a.length,--字段长度FIEldSize=ColUMNPROPERTY(a.ID,'PRECISION'),--字段大小FIEldScale=isnull(ColUMNPROPERTY(a.ID,'Scale'),0),--小数位数FIEldAllowNull=case when a.isnullable=1 then 'true' else 'false' end,--是否为空DefaultValue=isnull(e.text,''),--默认值FIEldRemark=isnull(g.[value],'')--字段说明FROM syscolumns aleft join systypes b on a.xtype=b.xusertypeinner join sysobjects d on a.ID=d.ID and d.xtype='U' and d.name<>'dtpropertIEs'left join syscomments e on a.cdefault=e.IDleft join sys.extended_propertIEs g on a.ID=g.major_ID and a.colID=g.minor_ID--sql2005--left join syspropertIEs g on a.ID=g.ID and a.colID=g.smallIDwhere d.name='tablename'order by a.ID,a.colorder

  总结

以上是内存溢出为你收集整理的获取SQLSERVER一张表里面的常用字段信息全部内容，希望文章能够帮你解决获取SQLSERVER一张表里面的常用字段信息所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。