Deleting a parent row is rejected while child rows exist.

Matching child rows are moved into the parent table.

Deleting a parent row sets the matching child foreign keys to NULL.

Deleting a row from the parent table deletes the matching rows in the child table, cascading further if needed.