community.borland.com

Article #25423: How to find out the table names in a database.

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