Custom Search
Update data in table with primary key and foreign key constraint
Wed, 01/04/2012 - 10:15
There are two tables Table A and Table B. Table A has a primary key and Table B has a foreign key constraint on the primary key of Table A.
Now how would you handle the following:-
[Case 1] update to data in primary key in Table A, consider this will violate foreign key constraint with child table
"; ; ; ; [Case 2] update to data in foreing key in Table B, consider this will violate foreign key constraint with parent table
Wed, 01/04/2012 - 10:43
#1
Read Update rule here...
Read the update rule in the following article to get the answer for your problem
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!