Good man!! now it is working perfectly.
Thank you very much for your quick and precise support.
Pumuky
Pumuky
Last Activity: Jan 15 '20, 03:08 PM
Joined: Sep 21 '07
Location:
-
Apologies for the inconvienences but It does not work as expected.
This is the FK that I have defined in LOAD_ACTIONS table
And when I execute the following query...Code:CONSTRAINT FK_ACTIONS2LOADS FOREIGN KEY(ACTION_FILENAME,ACTION_CHK_SUM) REFERENCES LOADS(FILENAME,CHK_SUM) ON DELETE CASCADE
...Code:SELECT acc1.table_name "PK TABLE",acc1.column_name "PK COLUMN",
Leave a comment:
-
Excuse me by the previous email, I have read another query.
Your query work but only in one direction. I complete it with an union and now it look likes that it is working
SELECT acc1.table_name "PK TABLE",acc1.col umn_name "PK COLUMN", acc2.table_name "FK TABLE", acc2.column_nam e "FK COLUMN"
FROM ALL_CONS_COLUMN S acc1,ALL_CONS_C OLUMNS acc2,ALL_CONSTR AINTS ac
WHERE ac.constraint_n ame...Leave a comment:
-
Thank you amitpatel66 but I think that I explained bad...
Your query return me all FK from one table and I need the FK name and the column name relationing two tables, I mean I have two tables and I need to know how they are relationated, obtaining their constraints and their column names.
Imagine that the query result is something like this
TABLE1, CONSTRAINT_NAME , COLUMN_NAME1, TABLE2, COLUMN_NAME2
...Leave a comment:
-
Getting the FKs established between two or more tables
Hi all,
I would need to know the way to get the FKs between two or more tables.
Could you help me?
Thank you in advance,
Pumuky -
Hi all,
the disscusion is very interesting... I would need to know the way to get the FK between two tables, could you help me?
Thank you in advance,
Pumuky...Leave a comment:
No activity results to display
Leave a comment: