James,

select rdb$relation_name from rdb$relations where rdb$relation_name not
starting 'RDB$';

I don't know how to do it without going to the database, unless you do
something with schema cache maybe.

HTH,

Brian

> -----Original Message-----
> From: James Bunting [mailto:jpb@...]
> Sent: Friday, 1 December 2000 8:43 PM
> To: IBObjects@egroups.com
> Subject: [IBO] Getting list of table names
>
>
> Hi,
>
> Can someone please tell me how to get a list of table names,
> preferably without querying the system database?
>
> TIA
>
>
> James Bunting
>
> Systematic Marketing Ltd
> http://www.systematicmarketing.com
> http://www.ukindex.co.uk
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9699/1/_/685810/_/975674573/
> --------------------------------------------------------------
> -------_->
>
>
>