Answer
A savepoint marks a position inside a transaction for partial rollback. • ROLLBACK TO SAVEPOINT undoes work performed after that mark. • The transaction can continue after rolling back to a savepoint. • COMMIT still completes the whole transaction.
💡 SQL Example
BEGIN;
SAVEPOINT before_optional_change;
UPDATE products SET price = -1;
ROLLBACK TO SAVEPOINT before_optional_change;
COMMIT;
Result
COMMIT
⚡ Quick Revision
A savepoint provides a partial rollback point inside a transaction.