|Subject||How to get the the tables and the columns of a Foreign Key?|
|Author||Walter R. Ojeda Valiente|
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
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.