查询orcal数据类型或列名

sybase

SELECT  DISTINCT case when syslength=0 then coltype+'('+string(length)+')' else coltype+'('+string(length)+','+string(syslength)+')'end  as 类型  FROM  columns where tname='tablename'

查询数据类型

orcal

SELECT *

  FROM user_tab_columns

 WHERE table_name = '大写表名'

select a.name as [column],b.name as type from syscolumns a,systypes b where a.id=object_id('表名') and a.xtype=b.xtype and a.name='列名'

SELECT * FROM "DBA"."pbcatcol" where pbc_tnam='tablename' --查询中文名字系统表