Listing of tables in DB

calahans · Jan 12, 2000

Hi, 
 
I'm looking to run an SQL to find the tables in a particular DB. I know SQL but am unfarmiliar with Informix. 
 
Any help appreciated. 
 
C

calahans · Jan 12, 2000

Found the solution myself: 
 
select * from systables

ravi · Jan 16, 2000

Hi, 
 
A better solution is 
select tabname from systables where tabid < 100; 
 
Tabid 1 - 100 are reserved for Informix's own use. 
 
HTH, 
Ravi...

ravi · Jan 16, 2000

oops, that should be 
select tabname from systables where tabid > 99; 
 
Tabid 1 - 99 are reserved for Informix's own use. 
 
HTH, 
Ravi...

calahans · Jan 17, 2000

Thanks - worked well