ASA SQL Reference
  SQL Statements

ROLLBACK TO SAVEPOINT statement

Description 

To cancel any changes made since a SAVEPOINT.

Syntax 

ROLLBACK TO SAVEPOINT [savepoint-name]

Usage 

The ROLLBACK TO SAVEPOINT statement will undo any changes that have been made since the SAVEPOINT was established. Changes made prior to the SAVEPOINT are not undone; they are still pending.

The savepoint-name is 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.

Permissions 

There must have been a corresponding SAVEPOINT within the current transaction.

Side effects 

None.

See also 

BEGIN TRANSACTION statement

COMMIT statement

RELEASE SAVEPOINT statement

ROLLBACK statement

SAVEPOINT statement

Savepoints within transactions

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• 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.

  For more information on nested transactions, see BEGIN TRANSACTION statement.