Board index » delphi » list of a database tables

list of a database tables

Frederic,

try this.

Tables without system tables:
select rdb$relation_name from rdb$relations where ((rdb$system_flag = 0) or
(rdb$system_flag is null)) and (rdb$view_source is null)

Tables AND Views without system tables:
select rdb$relation_name from rdb$relations where ((rdb$system_flag = 0) or
(rdb$system_flag is null))

--
Best Regards
Thomas Steinmaurer
IB LogManager - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com
"Frederic Gelinas" <fgeli...@si.qc.ca> schrieb im Newsbeitrag
news:3b2f5944$1_2@dnews...

Quote
> I'm sure there is a system table in IB6 that contains all table names.
What
> is the SQL statement to retrieve all the table names in a database
> (exculding system tables)?

> --
> Frederic Gelinas
> Programmeur-Analyste
> Si Informatique

 

Re:list of a database tables


I'm sure there is a system table in IB6 that contains all table names. What
is the SQL statement to retrieve all the table names in a database
(exculding system tables)?

--
Frederic Gelinas
Programmeur-Analyste
Si Informatique

Other Threads