Adding a Foreign Key without Constraints
For documentation purposes, I'd like to define a foreign key relationship between two entities, BUT I don't want any constraints put on the data. Yes, I realize this could "corrupt" my data, but my problem is I have an already designed schema with data already in place with some existing broken links. I do NOT want to delete that data (with the broken links) - it's history. But I would like to setup a visual model that shows the FK relationships for documentation purposes.
So essentially, I'd love to be able to say: ON UPDATE: IGNORE, ON DELETE: IGNORE
I considered adding the missing data, adding the FK's, then deleting the missing data again, but doing so may endanger the entire row of data in the referencing table, or is that only if the it's set to CASCADING?
Subject
Views
Written By
Posted
Adding a Foreign Key without Constraints
1249
November 07, 2012 04:03PM
960
November 09, 2012 03:14AM
850
November 09, 2012 08:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.