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

Sina · Oct 18, 2002

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 .

MartijnTonies · Oct 22, 2002

Hi,

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

A lot more is possible - if you go to

http://www.ibphoenix.com

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

http://www.upscene.com

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

http://www.interbaseworkbench.com

SreckoR · Oct 22, 2002

Use

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

Check system table for more infos

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!

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

Sina

Technical User

MartijnTonies

Programmer

SreckoR

Programmer

Similar threads

Part and Inventory Search

Sponsor