Firebird Documentation Index → Firebird 1.5 Language Ref. Update → Transaction control statements → ROLLBACK TO SAVEPOINT |
Available in: DSQL
Added in: 1.5
Description: Undoes everything that happened in a transaction since the creation of the savepoint.
Syntax:
ROLLBACK [WORK] TO [SAVEPOINT]name
ROLLBACK TO SAVEPOINT performs the following operations:
All the mutations performed within the transaction since the savepoint was created are undone.
All savepoints created after the one named are destroyed. All earlier savepoints are preserved, as is the savepoint itself. This means that you can rollback to the same savepoint several times.
All implicit and explicit record locks acquired since the savepoint are released. Other transactions that have requested access to rows locked after the savepoint must continue to wait until the transaction is committed or rolled back. Other transactions that have not already requested the rows can request and access the unlocked rows immediately.
For a full discussion of savepoints, see SAVEPOINT.
Firebird Documentation Index → Firebird 1.5 Language Ref. Update → Transaction control statements → ROLLBACK TO SAVEPOINT |