Subject How to get the the tables and the columns of a Foreign Key?
Author Walter R. Ojeda Valiente
Post date 2017-05-30T05:10:23Z
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.