隻說原理了，具體 可以自己使用程式去生成htm或word文檔。
1、首先擷取所有的表
SELECT name, id From sysobjects WHERE xtype = 'u' ORDER BY name ASC
2、根據表名查詢字段資訊
select syscolumns.name, syscolumns.length, systypes.name as typename, sys.extended_properties.[value] AS tname,syscolumns.isnullable 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= 't_sale')
