Transactions

Savepoint

English

Overview

A marker set partway through a transaction that lets you partially roll back to it.

Details

A checkpoint set within a transaction that lets you roll back partially to that point, rather than rolling back the entire transaction. For example, when looping through several operations inside a single transaction, a savepoint lets you roll back just to before the one that failed, without undoing the other operations that already succeeded.

More Database terms