constraint for replacing primary key
Posted by: ROB MARTINI
Date: January 22, 2020 09:50AM

If I have a table where primary key is composed by 4 attributes and I'm going to introduce the new attribute ID as primary key, which will replace the previous one. It's necessary to insert constraint for the 4 attributes? This constraint will avoid to insert records having the same values in 4 the attributes.
What do you think? It's necessary to insert the constraint?

Options: ReplyQuote


Subject
Written By
Posted
constraint for replacing primary key
January 22, 2020 09:50AM


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.