Problem: How to find out the table names in a database. Solution: /*******************************************************************************/ Note: The information in this article applies to InterBase v5.x /********************************************************************************/ This can be accomplished several different ways: 1. With a select query: (This can be used from an application) select rdb$relation_name from rdb$relations where rdb$system_flag=0; 2. In WISQL (This is specific to WISQL) You can use the Metadata | Show | Tables menu choices. If you do not enter anything in the object column, you will get a list of all tables in the database. 3. in ISQL (This is specific to ISQL) SHOW TABLES;
Last Modified: 27-OCT-00