referential action

The rule, declared on a foreign key, for what happens to child rows when the parent row they point at is deleted or changed.

In more detail

NO ACTION and RESTRICT refuse the delete while children exist, the safe default. CASCADE deletes the children too, and SET NULL keeps the children but clears their pointer. The choice belongs in the schema, not in each DELETE statement.

Related terms

Taught in

References