Interested to Buy Any Domain ? << Click Here >> for more details...
When can an insert of a new primary key value threaten
referential integrity?
- 2 Answers
- 7547 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 the meaning of -805 SQL return code?
Is it possible to precompile if db2 goes down?
how to resolve -811
Is db2 a programming language?
What is the difference between using bind () and rebind () methods of naming class?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
can we update the table by using cursors can anyone post the query?
Can there be more than one cursor open for any program?
What is the maximum number of columns in a db2 table?
What is a clustering index?
define clustering index.
What is the difference between Primary key and unique index?
COBOL 
