# DELETE

*noun*

say it: **“dih-LEET”** **/dɪˈliːt/**

The SQL statement that removes rows from a table.

## What does **DELETE** do in a relational database?

**DELETE** — A statement that removes selected rows from a table.

```sql
DELETE FROM customer
WHERE customer_id = 1;
```

## In a sentence

- “A **DELETE** with a WHERE removed only the discontinued products.”

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

Updated: November 9, 2026

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