Show TOC

ROLLBACK TO SAVEPOINT StatementLocate this document in the navigation structure

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

Quick Links:

Go to Parameters

Go to Standards

Go to Permissions

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 Database products—Savepoints are not supported by SAP ASE. To implement similar features in an SAP ASE-compatible manner, you can use nested transactions.
Permissions

(back to top)

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

Related Information