|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 2nd, 2005, 07:36 AM
|
|||
|
|||
|
How to get a list of tables in a database
I would like to get a list of the tables in a FireBird database. Like with 'show tables' in MySQL. How is this done in FireBird?
|
|
#2
February 2nd, 2005, 09:47 AM
|
|||
|
|||
|
Quote:
show table;
|
|
#3
February 2nd, 2005, 09:55 AM
|
|||
|
|||
|
Quote:
When I do this I get: Token unknown: show But I found the answer: SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NULL ORDER BY RDB$RELATION_NAME Sorry for the bad layout, but I could not get indent and the like to work.
|
|
#4
February 2nd, 2005, 12:38 PM
|
||||
|
||||
|
Quote:
Are you running it from ibeasy+ or other graphical client? It works fine from isql.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#5
February 3rd, 2005, 02:48 AM
|
|||
|
|||
|
Quote:
I did it from Database Workbench. It should work as a normal SQL statement (as my solution does), because it needs to be done from within a program.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > How to get a list of tables in a database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
