Subject Re: [firebird-support] List of Tables & Generators
Author Lee Jenkins
Helen Borrie wrote:
> At 10:09 PM 12/03/2004 -0500, you wrote:
>
>
>>Oh forgot to ask, what about getting a dataset of table names? :)
>
>
> SELECT RDB$RELATION_NAME FROM RDB$RELATIONS
> WHERE RDB$RELATION_NAME NOT STARTING WITH 'RDB$'
> AND RDB$VIEW_SOURCE IS NULL;
>
> All this stuff is in the Language Reference, under System Tables...
>
> /hb

Thanks Hellen, I wasn't aware of that. I will have a look at it and
thanks for taking the time.


--

Warm Regards,

Lee