Home > DeveloperSection > Interviews > What is a cascading update?

Posted on    August-24-2014 11:56 PM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  677  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    August-24-2014 12:00 AM

Referential integrity constraints require that foreign key values in one table correspond to primary key values in another. If the value of the primary key is changed -- that is, updated -- the value of the foreign key must immediately be changed to match it. Cascading updates will set this change to be done automatically by the DBMS whenever necessary.

Don't want to miss updates? Please click the below button!

Follow MindStick