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
http://fbexport.sourceforge.net
http://www.flamerobin.org