When can an insert of a new primary key value threaten
referential integrity?
Answers were Sorted based on User's Feedback
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 |
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 |
What is a SELECT statement?
What is the use of with ur in db2?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
what is SPUFI ?
How do you check for a null value in a db2 column?
How to test SQL -911 error while developing COB-DB2 program
When can an insert of a new primary key value threaten referential integrity?
How to design maps
what is load and unload in db2
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Where do you specify them?
How to check table size in db2 sap?