Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous

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

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.