Contact US

Question

Listing of tables in DB

calahans (Programmer)

(OP)

12 Jan 00 06:16

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 (Programmer) · Answer 1 · 2000-01-12 09:38:01

Found the solution myself:

select * from systables

ravi (Programmer) · Answer 2 · 2000-01-17 02:28:45

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 (Programmer) · Answer 3 · 2000-01-17 02:30:05

oops, that should be
select tabname from systables where tabid > 99;

Tabid 1 - 99 are reserved for Informix's own use.

HTH,
Ravi...

calahans (Programmer) · Answer 4 · 2000-01-17 11:45:54

calahans (Programmer)

(OP)

17 Jan 00 11:45

Thanks - worked well