查找表字段的类型

select systypes.name from sysobjects,systable,syscolumns,systypes where sysobjects.name=systable.etablename and systable.cfieldname='代码' and sysobjects.id=syscolumns.id and syscolumns.xtype=systypes.xtype and systable.ctablename='健康状况' and sysobjects.xtype='u' and syscolumns.name=systable.efieldname

上面是一个sql语句，systable是个表