How can I get a list of databases and tables in db?
How can I get a list of databases and tables in db?
(OP)
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 .
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 .
RE: How can I get a list of databases and tables in db?
From the command line tool "isql" - use SHOW TABLES
A lot more is possible - if you go to 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 www.upscene.com
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
RE: How can I get a list of databases and tables in db?
select RDB$RELATION_NAME from RDB$RELATIONS where RDB$RELATION_NAME not like 'RDB$%';
Check system table for more infos