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:
“It has lately been drawn to your correspondent’s attention that, at social gatherings, she is not the human magnet she would be. Indeed, it turns out that as a source of entertainment, conviviality, and good fun, she ranks somewhere between a sprig of parsley and a single ice- skate. It would appear, from the actions of the assembled guests, that she is about as hot company as a night nurse.”
—Dorothy Parker (1893–1967)