When can an insert of a new primary key value threaten referential integrity?

When can an insert of a new primary key value threaten
referential integrity?

Question Posted / guest

2 Answers
6347 Views
Mind Tree, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When can an insert of a new primary key value threaten referential integrity?..

Answer / naveen

When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.

RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with

Is This Answer Correct ?

4 Yes

0 No

When can an insert of a new primary key value threaten referential integrity?..

Answer / pawan

when the value violates the rule of primary key....new
insert value must be unique.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer