Subject | Re: Retreiving Database structure from Meta Data |
---|---|
Author | waynebrsa |
Post date | 2004-05-17T17:15:18Z |
Hi Helen
Maybe i did not explain myself to well.
I am a programmer and i am busy to write a program that constructs
classes depending on the structure of the database.
I am not looking for an ERD program. I am looking for a ERD that can
tell me how the system tables in FireBird are connected so that i
can construct SQL statements like below.
For Example:
Select RF.RDB$FIELD_NAME,
F.RDB$FIELD_LENGTH,
From RDB$RELATION_FIELDS RF,
RDB$FIELDS F
Where RF.RDB$RELATION_Name = 'EMPLOYEE'
And RF.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
Thanks
Wayne
Maybe i did not explain myself to well.
I am a programmer and i am busy to write a program that constructs
classes depending on the structure of the database.
I am not looking for an ERD program. I am looking for a ERD that can
tell me how the system tables in FireBird are connected so that i
can construct SQL statements like below.
For Example:
Select RF.RDB$FIELD_NAME,
F.RDB$FIELD_LENGTH,
From RDB$RELATION_FIELDS RF,
RDB$FIELDS F
Where RF.RDB$RELATION_Name = 'EMPLOYEE'
And RF.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
Thanks
Wayne