SELECT (CASE WHEN b.colorder = 1 OR
      b.colorder IS NULL THEN a.name ELSE '' END) AS N'表名', b.name AS N'字段名',
      C.NAME AS N'数据类型', b.prec AS N'长度',
      (CASE WHEN b.colstat = 4 THEN '√' ELSE '' END) N'是否输出',
      b.colorder N'字段序号', (CASE WHEN b.colorder = 1 OR
      b.colorder IS NULL THEN d .text ELSE '' END) AS N'内容'
FROM sysobjects a LEFT JOIN
      syscolumns b ON b.id = a.id LEFT JOIN
      systypes C ON (C.xtype = B.xtype AND c.name <> 'sysname') LEFT JOIN
      syscomments d ON d .id = a.id
WHERE a.schema_ver = 0 AND a.xtype = 'p'
ORDER BY a.name, b.colorder

评论