SAVEPOINT

A checkpoint set inside a transaction, so you can roll back to it without undoing the whole transaction.

sql
SAVEPOINT after_first_update;
ROLLBACK TO after_first_update;

When to use

Used with ROLLBACK TO to undo only part of a Transaction. Covered in the study guide's transactions section only.

See Read 01.

Appears in

No references yet.