sql2005sql2008导出数据字典方法

表名 = d.name,表说明 = isnull (f.value, '' ) , 字段序号 = a.colorder,字段名 = a.name,标识 ( a.id,a.name,) ,主键 (sysobjects name in ( SELECT name FROM sysindexes WHERE indid in ( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid = a

表名=d.name, 表说明=isnull(f.value,'') , 字段序号=a.colorder, 字段名=a.name, 标识( a.id,a.name,), 主键(sysobjects name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid ))) , 类型=b.name, 占用字节数=a.length, 长度), 小数位数),0), 允许空a.isnullable, 默认值=isnull(e.text,''), 字段说明,'') FROM syscolumns a left join systypes b on a.xtype=b.xusertype d.namesyscomments e on a.cdefault=e.id left join sys.extended_properties g on a.id=g.major_id and a.colid=g.minor_id d.name,a.id,a.colorder