Foreign Key - Referential Actions

Referential Actions

Because the database management system enforces referential constraints, it must ensure data integrity if rows in a referenced table are to be deleted (or updated). If dependent rows in referencing tables still exist, those references have to be considered. SQL:2003 specifies 5 different referential actions that shall take place in such occurrences:

  • CASCADE
  • RESTRICT
  • NO ACTION
  • SET NULL
  • SET DEFAULT

Read more about this topic:  Foreign Key

Famous quotes containing the word actions:

    What is the use of aesthetics if they can neither teach how to produce beauty nor how to appreciate it in good taste? It exists because it behooves rational human beings to provide reasons for their actions and assessments. Even if aesthetics are not the mathematics of beauty, they are the proof of the calculation.
    Franz Grillparzer (1791–1872)