sqlserver数据字典导出excel.doc

《sqlserver数据字典导出excel.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、SELECT表名=casewhena.colorder=1thend.nameelse''end,表说明=casewhena.colorder=1thenisnull(f.value,'')else''end,字段序号=a.colorder,字段名=a.name,标识=casewhenCOLUMNPROPERTY(a.id,a.name,'IsIdentity')=1then'√'else''end,主键=casewhenexists(SELECT1FROMsysobjectswherextype='PK'andnamein(SELECTnameF

2、ROMsysindexesWHEREindidin(SELECTindidFROMsysindexkeysWHEREid=a.idANDcolid=a.colid)))then'√'else''end,类型=b.name,占用字节数=a.length,长度=COLUMNPROPERTY(a.id,a.name,'PRECISION'),小数位数=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),允许空=casewhena.isnullable=1then'√'else''end,默认值=isnull(e.t

3、ext,''),字段说明=isnull(g.[value],'')FROMsyscolumnsaleftjoinsystypesbona.xtype=b.xusertypeinnerjoinsysobjectsdona.id=d.idandd.xtype='U'andd.name<>'dtproperties'leftjoinsyscommentseona.cdefault=e.idleftjoinsys.extended_propertiesgona.id=g.major_idanda.colid=g.minor_idleftjoinsys.ex

4、tended_propertiesfond.id=f.major_idandf.minor_id=0--whered.name='要查询的表'--如果只查询指定表,加上此条件orderbya.id,a.colorder