Listing of tables in DB
Listing of tables in DB
(OP)
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
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
RE: Listing of tables in DB
select * from systables
RE: Listing of tables in DB
A better solution is
select tabname from systables where tabid < 100;
Tabid 1 - 100 are reserved for Informix's own use.
HTH,
Ravi...
RE: Listing of tables in DB
select tabname from systables where tabid > 99;
Tabid 1 - 99 are reserved for Informix's own use.
HTH,
Ravi...
RE: Listing of tables in DB