Hi Alessandro/Martijn,

>>Hi,
>>
>> Which "rdb$" Do I need do a select to find my tables in firebird ?
>>
>>table rdb$tables doesn't exists.
>
> Try the Language Reference - chapter "System Tables and Views".

just in case you don't have that at hand ;-)

it's called RDB$RELATIONS, not TABLES. something like this should work:

select RDB$RELATION_NAME
from RDB$RELATIONS
where RDB$SYSTEM_FLAG=0
order by RDB$RELATION_NAME

(leave out the where clause in case you want the RDB$ tables themselves, too)

hth,
fingerman

--
-------------------------------------------------------------------------
when parsers parse, and compilers compile, then why don't objects object?

fingerbirdy - fingerman's door to Firebird
http://www.fingerbird.de