# SAVEPOINT

A named point inside a transaction to which later work can be rolled back.

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

**SAVEPOINT** — A named point inside a transaction to which later work can be rolled back.

```sql
START TRANSACTION;
SAVEPOINT before_discount;
UPDATE product
SET price = price * 0.90;
ROLLBACK TO SAVEPOINT before_discount;
```

Level: Journeyman · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/journeyman)

Updated: September 27, 2026

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