Search the archives for 'HANDY SCRIPT' - there's a few solutions to
questions like this one.

In a nutshell, do something like:
SELECT distinct(a.rdb\$relation_name) as str_tablename from rdb\
$relation_fields a where a.rdb\$relation_name NOT CONTAINING 'RDB\$'

nige.

----- Original Message -----
From: "Michael Fung" <ibo@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, September 03, 2004 1:15 PM
Subject: [firebird-support] Help: how to get all table names?


> Dear all,
>
> 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.)
>
> TIA,
> Michael
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> __________ NOD32 1.858 (20040901) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>