sql2000表结构字段信息
SELECT TOP 100 PERCENT c.name AS column1, '' as column2, t.name AS column3, c.length AS column4, case c.isnullable when 1 then '√' else '' end AS column5, e.text AS column6FROM dbo.syscolumns c INNER JOIN dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, N'IsUserTable') = 1 AND o.name <> 'dtproperties' INNER JOIN dbo.systypes t ON t.xusertype = c.xusertype LEFT OUTER JOIN dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorderleft OUTER join syscomments eon c.cdefault=e.id WHERE o.NAME = 'ALARM_DESCRIBE'ORDER BY o.name, c.colid
?
