Try the following:

Use the sysmaster DB. Then:

SELECT tabname 
FROM systabnames 
WHERE dbsname = '$your_db_name'
[ AND owner <> 'informix' ] <- Assuming you were not logged in as
informix when you created the tables
[ AND tabname NOT LIKE ' %' ] <- If you use blobs you may have some
numeric tables I think

The stuff in the square brakets is optional. Informix throughs in a lot
of system tables and hidden tables.

The systabnames table is in the sysmaster database and has the following

partnum, dbsname, owner, tabname, collate

Hope this helps.


> Any idea how to extract table names for a database in informix - like the
> sql for mysql SHOW TABLES;
> ??
> J

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to