Description
The RELEASE SAVEPOINT command removes a save-point
from the transaction log. It indicates that any modifications
made since the named save-point was set have been accepted by
the application logic.
Normally, a RELEASE will not alter the
database or transaction log, other than removing the save-point
marker. Releasing a save-point will not commit any modifications
to disk, nor will it make those changes available to other
database connections accessing the same database. Changes
bounded by a released save-point may still be lost if the
transaction is rolled back to a prior save-point, or if the
whole transaction is rolled back.
The one exception to this rule is if the named save-point was set outside of a transaction, causing an implicit transaction to be started. In that case, releasing the save-point will cause the whole transaction to be committed.