Subject Re: [firebird-support] Help: how to get all table names?
Author Milan Babuskov
Michael Fung wrote:
> How to get all the table names in a database with a select statement?
> (Because I want to auto create a script to add a trigger for all
> 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

Milan Babuskov