Hallo,
rdb$relation_fields, ups hattest du ja?
Hier hast du die notwendigen Relationen (ohne das "neue" Join).
SQL.Add('SELECT');
SQL.Add(' F.RDB$RELATION_NAME As TableName,');
SQL.Add(' F.RDB$FIELD_NAME As FieldName,');
SQL.Add(' RDB$FIELD_LENGTH As FieldLength,');
SQL.Add(' RDB$TYPE_NAME As DataType');
SQL.Add('FROM RDB$RELATION_FIELDS F, RDB$Fields M, RDB$TYPES T');
SQL.Add('Where F.RDB$FIELD_SOURCE=M.RDB$FIELD_NAME');
SQL.Add('And T.RDB$FIELD_NAME="RDB$FIELD_TYPE"');
SQL.Add('And T.RDB$TYPE=RDB$FIELD_TYPE');
SQL.Add('AND F.RDB$SYSTEM_FLAG=0');
Und noch 3 Links mit einer paar Tips zu System-Tabellen (
DB-Schema)
https://firebirdsql.org/file/documen...systables.html
http://www.firebirdfaq.org/faq174/
https://www.alberton.info/firebird_s...l#.XAhtIWhKhEY