SqlServer快速导出数据库结构的方法

1、查询出所有的表

SELECT name, id From sysobjects WHERE xtype = 'u' ORDER BY name ASC 

2、根据表名查询出表结构
select syscolumns.name as "列名", systypes.name   as   "数据类型", syscolumns.length as "数据长度", sys.extended_properties.[value] AS "标识",case syscolumns.isnullable when 1 then '允许' when 0 then '不允许' end as "是否为空"
from   syscolumns join systypes   on     syscolumns.xtype=systypes.xtype   
and   systypes.name <> 'sysname' LEFT OUTER JOIN sys.extended_properties ON 
( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) where   syscolumns.id   in (select   id   from   sysobjects   where   name= 'Asx_4DU_3654')

3、将表结构复制到word文档，搞定

 

 文件引用路径：sqlserver生成表结构文档的方法