[firebird-support] How to get the the tables and the columns of a Foreign Key?

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

Hello everybody

I had defined a Foreign Key as:

ALTER TABLE ADHERENTES
ADD CONSTRAINT FK_ADHERENTES
FOREIGN KEY (ADH_SERVID, ADH_IDECAB)
REFERENCES CLIENTES(CLI_SERVID, CLI_IDENTI)
ON DELETE CASCADE
ON UPDATE CASCADE;

Of course, that work very well.

However, after watching the system tables I can not find a simple way to
build a SELECT what can give me the name of the tables and the columns
involved. Something as:

SELECT ... something

Result:
ADHERENTES, ADH_SERVID, ADH_IDECAB, CLIENTES, CLI_SERVID, CLI_IDENTI

Can somebody tell me how to get that result?

Thank you very much in advance.

Greetings.

Walter.