# ON DELETE CASCADE

*noun*

say it: **“on dih-LEET kas-KAYD”** **/ɑn dɪˈlit kæsˈkeɪd/**

A rule on a SQL foreign key that deletes the rows pointing at a row whenever that row is deleted.

## What does **ON DELETE CASCADE** do?

**ON DELETE CASCADE** is a rule on a foreign key: when a row is deleted, the rows pointing at it are deleted too. It
fits rows that mean nothing alone, such as a vendor's products. Without it, deleting a vendor that still has products
is refused. (SQLite checks foreign keys only after `PRAGMA foreign_keys = ON`.)

```sql
CREATE TABLE products (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    vendor_id INTEGER NOT NULL REFERENCES vendors (id) ON DELETE CASCADE
);

DELETE FROM vendors WHERE id = 1;   -- vendor 1's products are deleted with it
```

## In a sentence

- “Products mean nothing without their vendor, so the products table's foreign key uses **ON DELETE CASCADE**.”
- “With **ON DELETE CASCADE** on vendor_id, removing Hilltop Honey removed its three products too.”

Level: Journeyman · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/on-delete-cascade
