RELEASE SAVEPOINT statement

Description

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

For a description of savepoints, see Chapter 8, “Using Procedures and Batches” in the Sybase IQ System Administration Guide. Releasing a savepoint does not do any type of COMMIT. It simply removes the savepoint from the list of currently active savepoints.

Side effects

None.

Standards

SQL/92 Vendor extension.

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

Permissions

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