[转载]查询所有Informix数据表字段类型SQL语句
查询所有Informix数据表字段类型SQL语句:
select a.tabname,b.colname,b.coltype,
case?? b.coltype?
when '0' then 'CHAR'?
when '1' then 'SMALLINT'?
when '2' then 'INTEGER'?
when '3' then 'FLOAT'?
when '4' then 'SMALLFLOAT'?
when '5' then 'DECIMAL'?
when '6' then 'SERIAL'?
when '7' then 'DATE'?
when '8' then 'MONEY'?
when '9' then 'NULL'?
when '10' then 'DATETIME'?
when '11' then 'BYTE'?
when '12' then 'TEXT'?
when '13' then 'VARCHAR'?
when '14' then 'INTERVAL'?
when '15' then 'NCHAR'?
when '16' then 'NVARCHAR'
when '17' then 'INT8'?
when '18' then 'SERIAL8'?
when '19' then 'SET'?
when '20' then 'MULTISET'?
when '21' then 'LIST'?
when '22' then 'Unnamed ROW'?
when '40' then 'LVARCHAR'?
when '41' then 'CLOB'?
when '43' then 'BLOB'?
when '44' then 'BOOLEAN'?
when '256' then 'CHAR'?
when '257' then 'SMALLINT'?
when '258' then 'INTEGER'?
when '259' then 'FLOAT'?
when '260' then 'REAL'?
when '261' then 'DECIMAL'?
when '262' then 'SERIAL'?
when '263' then 'DATE'?
when '264' then 'MONEY'?
when '266' then 'DATETIME'?
when '267' then 'BYTE'?
when '268' then 'TEXT'?
when '269' then 'VARCHAR'?
when '270' then 'INTERVAL'?
when '271' then 'NCHAR'?
when '272' then 'NVARCHAR'
when '273' then 'INT8'?
when '274' then 'SERIAL8'?
when '275' then 'SET'?
when '276' then 'MULTISET'?
when '277' then 'LIST'?
when '278' then 'Unnamed ROW'?
when '296' then 'LVARCHAR'?
when '297' then 'CLOB'?
when '298' then 'BLOB'?
when '299' then 'BOOLEAN'
when '4118' then 'Named ROW'?
end?? as?? coltypename, b.colno? from systables a left join syscolumns b on a.tabid=b.tabid where a.tabid>99 and a.tabtype='T' order by a.tabname,b.colno;
