User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

Release a savepoint within the current transaction.

Syntax

     RELEASE SAVEPOINT [savepoint-name]

Usage

Anywhere.

Permissions

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

Side effects

None.

See also

• SAVEPOINT statement
• ROLLBACK TO SAVEPOINT statement

Description

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 "Savepoints within transactions". Releasing a savepoint does not do any type of commit. It simply removes the savepoint from the list of currently active savepoints.