What does `ON DELETE CASCADE` on a foreign key constraint do?

Question

Advanced SQL Developer — Medium

What does `ON DELETE CASCADE` on a foreign key constraint do?

Accepted Answer

`ON DELETE CASCADE` automatically deletes child rows when their referenced parent row is deleted, ensuring referential integrity. This means that child rows are removed without the need for explicit deletions before removing the parent row.