SELECT d.name, a.name AS Expr1, ISNULL(b.[value], '') AS 字段说明
FROM syscolumns a LEFT OUTER JOIN
sysproperties b ON a.id = b.id AND a.colid = b.smallid INNER JOIN
sysobjects d ON a.id = d.id AND d.xtype = 'u' AND d.name <> 'dtproperties'
order by d.name,a.name