Releases a savepoint within the current transaction.
Syntax
RELEASE SAVEPOINT [ savepoint-name ]
Parameters
(back to top)
- 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
(back to top)
Releasing
a savepoint does not perform any type of COMMIT; it
simply removes the savepoint from the list of currently active savepoints.
Standards
(back to top)
- SQL—Vendor extension to ISO/ANSI SQL grammar.
- SAP Sybase Database product—Not supported by Adaptive Server. A similar feature is available in an
Adaptive Server-compatible manner using nested
transactions.
Permissions
(back to top)
There must have been a corresponding SAVEPOINT within the current transaction.