Firebird: Foreign Keys aus Metadaten auslesen

[alex517]

Damit kann man auch die beteiligten Felder sehen.

SQL-Code:

SELECT
  S.RDB$INDEX_NAME,
  S.RDB$RELATION_NAME,
  S.RDB$FOREIGN_KEY,
  SS.RDB$FIELD_NAME,
  M.RDB$INDEX_NAME,
  M.RDB$RELATION_NAME,
  MS.RDB$FIELD_NAME
FROM
  RDB$INDICES S
  JOIN RDB$INDICES M ON (M.RDB$INDEX_NAME = S.RDB$FOREIGN_KEY)
  JOIN RDB$INDEX_SEGMENTS SS ON (SS.RDB$INDEX_NAME=S.RDB$INDEX_NAME)
  JOIN RDB$INDEX_SEGMENTS MS ON (MS.RDB$INDEX_NAME=M.RDB$INDEX_NAME)