Update data in table with primary key and foreign key constraint
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
Read the update rule in the following article to get the answer for your problem