Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I get a list of databases and tables in db?

Status
Not open for further replies.

Sina

Technical User
Jan 2, 2001
309
CA
Hello all,

what is the command to get a list of the
database and tables in each database in Interbase?

how to list all the indexes, Pk, FK via sql in interbase?

Thank you .
 
Hi,

From the command line tool "isql" - use SHOW TABLES

A lot more is possible - if you go to and to "Main Downloads" there's a link to the "IB6 beta documentation set" - a collection of PDFs with lots of information.

If you want a full-working development IDE - check out InterBase Workbench at
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
 
Use

select RDB$RELATION_NAME from RDB$RELATIONS where RDB$RELATION_NAME not like 'RDB$%';

Check system table for more infos
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top