Oct 18, 2002 #1 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 .
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 .
Oct 22, 2002 #2 MartijnTonies Programmer Jun 5, 2002 212 NL 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 Upvote 0 Downvote
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
Oct 22, 2002 #3 SreckoR Programmer Oct 22, 2002 2 BA Use select RDB$RELATION_NAME from RDB$RELATIONS where RDB$RELATION_NAME not like 'RDB$%'; Check system table for more infos Upvote 0 Downvote
Use select RDB$RELATION_NAME from RDB$RELATIONS where RDB$RELATION_NAME not like 'RDB$%'; Check system table for more infos