效果如下： 1，在对应库中执行如下查询，不带标题复制查询结果， SELECT CASE WHEN col.colorder = 1 THEN '

'+obj.name+'：'+cast( ISNULL(epTwo.[value],'') as varchar(1000))+'

' ELSE '' END AS 表名, ''AS 序号 , -- '' AS 列名 , '' AS 列名 , '' AS 列说明 , '' AS 数据类型 , '' AS 长度 , ''AS 小数位数 , CASE WHEN COLUMNPROPERTY(col.id, col.name, 'IsIdentity') = 1 THEN '' ELSE '' END AS 标识 , CASE WHEN EXISTS ( SELECT 1 FROM dbo.sysindexes si INNER JOIN dbo.sysindexkeys sik ON si.id = sik.id AND si.indid = sik.indid INNER JOIN dbo.syscolumns sc ON sc.id = sik.id AND sc.colid = sik.colid INNER JOIN dbo.sysobjects so ON so.name = si.name AND so.xtype = 'PK' WHERE sc.id = col.id AND sc.colid = col.colid ) THEN '' ' END AS 主键 , CASE WHEN col.isnullable = 1 THEN '' ELSE '' END AS 允许空 , '' AS 默认值 FROM dbo.syscolumns col LEFT JOIN dbo.systypes t ON col.xtype = t.xusertype inner JOIN dbo.sysobjects obj ON col.id = obj.id AND obj.xtype = 'U' AND obj.status >= 0 LEFT JOIN dbo.syscomments comm ON col.cdefault = comm.id LEFT JOIN sys.extended_properties ep ON col.id = ep.major_id LEFT JOIN sys.extended_properties epTwo ON obj.id = epTwo.major_id AND col.colid = ep.minor_id AND ep.name = 'MS_Description' AND epTwo.minor_id = 0 AND epTwo.name = 'MS_Description' obj.name in(select name from sys.tables where name not like '%_201%')--表名，这里我过滤了备份的表 WHERE order by obj.id,col.colorder --SELECT * FROM sys.extended_properties A 2，将上面结果复制到如下的文本中，的标签里，表格样式可以修改。 文本保存为 html。 直接双击 html 文件，效果如下： 

序号	列名	列说明	数据类型	长度	小数位数	标识	主 键	允许空	默认值
' +cast(col.colorder as varchar(100)) +'	'+col.name+'	'+cast(col.name as varchar(100))+'	' + cast(ISNULL(ep.[value], '')as varchar(100)) +'	' +cast( t.name as varchar(100)) +'	' +cast( col.length as varchar(100)) +'	' + cast( ISNULL(COLUMNPROPERTY(col.id, col.name, 'Scale'), 0) as varchar(100)) +'	√		√		√		' + ISNULL(comm.text, '') +'