Jon, 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 fields: partnum, dbsname, owner, tabname, collate Hope this helps. Dan > Any idea how to extract table names for a database in informix - like the > sql for mysql SHOW TABLES; > > ?? > > J -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]