sql2000表结构字段信息SELECT TOP 100 PERCENT c.name AS column1, as column2,t.name AS column3, c.l
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
?