sqlserver导出 数据字典的SQL语句

在网上查找到的资料经本人使用 有效 SELECT??? ? ?? ? ? 表名=case?? when?? a.colorder=1?? then? d.name?? else?? ''? end,?? ? ?? ? ? 表说明=case?? when?? a.colorder=1?? then? isnull(f.value,'')?? 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?? name? in?? (?? ? ?? ? ? SELECT? name?? FROM?? sysindexes? WHERE?? indid?? in(?? ? ?? ? ? SELECT? indid?? FROM?? sysindexkeys?? WHERE? id?? =?? a.id? AND?? colid=a.colid?? ? ?? ? ? )))?? then? '√'? else?? ''?? end,?? ? ?? ? ? 类型=b.name,?? ? ?? ? ? 占用字节数=a.length,?? ? ?? ? ? 长度=COLUMNPROPERTY(a.id,'PRECISION'),?? ? ?? ? ? 小数位数=isnull(COLUMNPROPERTY(a.id,'Scale'),0),?? ? ?? ? ? 允许空=case?? when?? a.isnullable=1?? then? '√'else?? ''? end,?? ? ?? ? ? 默认值=isnull(e.text,''),?? ? ?? ? ? 字段说明=isnull(g.[value],'')?? ? ?? ? ? FROM? syscolumns?? a?? ? ?? ? ? left? join?? systypes?? b?? on?? a.xtype=b.xusertype?? ? ?? ? ? inner? join?? sysobjects?? d?? on?? a.id=d.id??? and?? d.xtype='U'?? and??? d.name<>'dtproperties'? ? ?? ? ? left? join?? syscomments?? e?? on?? a.cdefault=e.id?? ? ?? ? ? left? join?? sys.extended_properties g?? on? a.id=g.major_id?? and?? a.colid=g.minor_id????????? ? ?? ? ? left? join?? sys.extended_properties f?? on? d.id=f.major_id?? and?? f.minor_id? =0?? ? ?? ? ? --where?? d.name='要查询的表'???????? --如果只查询指定表,加上此条件?? ? ?? ? ? order? by?? a.id,a.colorder? ?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!