ROLLBACK TO SAVEPOINT Statement

Cancels any changes made since a savepoint was established. Changes made prior to the savepoint are not undone; they are still pending.

Syntax

ROLLBACK TO SAVEPOINT [ savepoint-name ]

Parameters

savepoint-name – an identifier that was specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is used. Any savepoints since the named savepoint are automatically released.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Savepoints are not supported by Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, you can use nested transactions.

Permissions

None, but there must have been a corresponding SAVEPOINT within the current transaction.

Parent topic: SQL Statements

Related reference

RELEASE SAVEPOINT Statement

ROLLBACK Statement

SAVEPOINT Statement

Created May 22, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com