得到SQL SERVER 2000下的表结构

use ogvas
select s.colorder,s.name, t.name , s.length , s.isnullable --,s.type, s.xtype, s.xusertype, s.prec, s.scale
from [OGVAS].dbo.syscolumns  s,sysobjects o, systypes t
 where s.id = o.id and lower(o.name) = lower('application')
 and ( t.type = s.type  and t.xtype = s.xtype )
 order by s.colorder