sql2005(含“说明”字段)数据库设计文档自动生成方法

SELECT     TOP (100) PERCENT s.tablename AS 表名, s.columnname AS 字段名, s.type AS 类型, s.length AS 长度, c.value AS 字段说明, s.xprec, s.xscale, s.id,
                      s.colid
FROM        (SELECT     TOP (100) PERCENT o.name AS tablename, c.name AS columnname, t.name AS type, c.length, c.xprec, c.xscale, c.id, c.colid, CONVERT(varchar(20),
                      c.id) + '|' + CONVERT(varchar(20), c.colid) AS myid
FROM         sys.sysobjects AS o INNER JOIN
                      sys.syscolumns AS c ON o.id = c.id INNER JOIN
                      sys.systypes AS t ON c.xtype = t.xtype
WHERE     (o.xtype = 'U')
ORDER BY tablename) AS s LEFT OUTER JOIN
                      (SELECT     CONVERT(varchar(20), major_id) + '|' + CONVERT(varchar(20), minor_id) AS myid, class, class_desc, major_id, minor_id, name, value
FROM         sys.extended_properties) AS c ON s.myid = c.myid
ORDER BY 表名, s.colid