Hello Andi,

> What's the SQL Command (with select command) to display all tables
> on the database?

All this info is available in the system tables, contained in each Firebird
database.

Tables and Views can be found in RDB$RELATIONS --

Tables:

select *
from rdb$relations
where rdb$view_blr is null

Views:

select *
from rdb$relations
where rdb$view_blr is not null

Filter system tables by doing:
and rdb$system_flag is null or rdb$system_flag = 0

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com