sql2000表结构字段信息
如下：
Sql代码
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 column6
FROM 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.colorder
left OUTER join syscomments e
on c.cdefault=e.id
WHERE o.NAME = 'ALARM_DESCRIBE'
ORDER BY o.name, c.colid