What are foreign key cascade options?

Question

Accepted Answer

## Foreign Key Cascade Options When a parent row is **deleted** or **updated**, the cascade option determines what happens to the child rows that reference it: | Option | On DELETE | On UPDATE | |---|---|---| | `CASCADE` | Delete all child rows | Update child FK values to match new parent PK | | `SET NULL` | Set child FK column to NULL | Set child FK column to NULL | | `SET DEFAULT` | Set child FK to its default value | Set child FK to its default value | | `RESTRICT` | Block the delete if children exist | Block the update if children exist | | `NO ACTION` | Same as RESTRICT (checked at statement end) | Same as RESTRICT (checked at statement end) |

What are foreign key cascade options?

Understand the problem

Attempt it yourself

Stuck? AI Nudge Available

Study the solution

The solution is waiting

Run the code

Join the discussion

Discussion (0)