SyBase IQ 显示字段列表
SyBase IQ 有没有类似select name from syscolumns where id=object_id('') 的语句来列表一个表的所有字段?
[解决办法]
--查看当前数据库中的用户表
select * from sysobjects where type='U'
--查看当前表的信息
select sysobjects.name, systypes.name, syscolumns.length, syscolumns.name
from syscolumns,systypes,sysobjects
where syscolumns.usertype = systypes.usertype
and syscolumns.id = sysobjects.id
and sysobjects.name = 'wjj'
