RELEASE SAVEPOINT Statement

Releases a savepoint within the current transaction.

Syntax

RELEASE SAVEPOINT [ savepoint-name ]

Parameters

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

Usage

Releasing a savepoint does not perform any type of COMMIT; it simply removes the savepoint from the list of currently active savepoints.

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
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.

Parent topic: SQL Statements

Related reference

ROLLBACK TO SAVEPOINT Statement

SAVEPOINT Statement

Created May 22, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com