Subject Re: [firebird-support] Get create table SQL from system tables
Author Ann W. Harrison
Martijn Tonies wrote:
>>
>> Firebird stores its metadata in normalized relational tables not
>> .frm files. To be confusing, it uses somewhat archaic academic
>> terminology. You'll find tables and views in RDB$RELATIONS,
>> domains in RDB$FIELDS, columns in RDB$RELATION_FIELDS, the mapping
>> from views to tables in RDB$VIEW_RELATIONS, etc. The extract.cpp
>> file in ISQL has all the code to recreate definitions.
>
> Couldn't remember if ISQL did that ;-)
>
> Anyway, Ann, does ISQL also support metadata for single objects?
>

No, you'd have to go find your table in the list of create table
statements extracted. But all the logic to create them is in
ISQL extract... at least all the logic to extract FB1.0 was there.


Best,

Ann