Reference Manual
   CHAPTER 9. SQL Statements     

RELEASE SAVEPOINT statement

Function 

Release a savepoint within the current transaction.

Syntax 

RELEASE SAVEPOINT [savepoint-name]

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.

Standards and compatibility 

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