SELECT  ( CASE WHEN a.colorder = 1 THEN d.name               ELSE ‘‘          END ) 表名 ,        a.colorder 字段序号 ,        a.name 字段名 ,        g.[value] AS 字段说明FROM    syscolumns a        LEFT JOIN systypes b ON a.xtype = b.xusertype        INNER JOIN sysobjects d ON a.id = d.id                                   AND d.xtype = ‘U‘                                   AND d.name <> ‘dtproperties‘        LEFT JOIN sys.extended_properties g ON a.id = g.major_id                                               AND a.colid = g.minor_id--WHERE d.[name] <>‘table_desc‘ --你要查看的表名，注释掉，查看当前数据库所有表的字段信息WHERE   d.[name] = ‘Rep_HandleStats_Week‘--你要查看的表名，注释掉，查看当前数据库所有表的字段信息ORDER BY a.id ,        a.colorder;