SAVEPOINT
A checkpoint set inside a transaction, so you can roll back to it without undoing the whole transaction.
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.