WHAT IS A CASCADING UPDATE?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 864  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is a cascading update?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!