Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Releases a savepoint within the current transaction.
RELEASE SAVEPOINT [ savepoint-name ]
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.
Releasing a savepoint does not do any type of COMMIT. It simply removes the savepoint from the list of currently active savepoints.
There must have been a corresponding SAVEPOINT within the current transaction.
RELEASE SAVEPOINT is part of optional SQL/2008 language feature T271, "Savepoints".