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
(back to top)
- 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
(back to top)
- SQL—Vendor extension to ISO/ANSI SQL grammar.
- SAP Sybase Database product—Savepoints are not supported by
Adaptive Server. To implement similar features
in an Adaptive Server-compatible manner, you can
use nested transactions.
Permissions
(back to top)
None, but there must have been a corresponding SAVEPOINT within the current transaction.