Subject Re: Retreiving Database structure from Meta Data
Author waynebrsa
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