question on identifying relationships
Posted by: Chris Bassett
Date: July 14, 2013 05:18PM

In terms of identifying relationships between tables, isn't using a PK from one table as a FK in another table duplication of data? What happens if you needed to change the PK of a row that appears as a FK of another table (I know that isn't really a common practice, but what if you had to change it). Would it also change across all tables in the database where the PK is a FK?

Options: ReplyQuote


Subject
Written By
Posted
question on identifying relationships
July 14, 2013 05:18PM


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.