Subject | Re: [firebird-support] Get create table SQL from system tables |
---|---|
Author | Ann W. Harrison |
Post date | 2009-12-20T18:49:32Z |
Martijn Tonies wrote:
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
>>No, you'd have to go find your table in the list of create table
>> 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?
>
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