ASA SQL Reference
  SQL Statements

RELEASE SAVEPOINT statement

Description 

Use this statement to release a savepoint within the current transaction.

Syntax 

RELEASE SAVEPOINT [savepoint-name]

Usage 

Release a savepoint. The savepoint-name is an identifier specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is released.

Releasing a savepoint does not do any type of COMMIT. It simply removes the savepoint from the list of currently active savepoints.

Permissions 

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

Side effects 

None.

See also 

BEGIN TRANSACTION statement

COMMIT statement

ROLLBACK statement

ROLLBACK TO SAVEPOINT statement

SAVEPOINT statement

Savepoints within transactions

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise. A similar feature is available in an Adaptive Server Enterprise-compatible manner using nested transactions.