Use this statement to release a savepoint within the current transaction.

Syntax

RELEASE SAVEPOINT [ savepoint-name ]

Remarks

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.

Permissions

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

Side effects

None.

See also

• BEGIN TRANSACTION statement [T-SQL]
• COMMIT statement
• ROLLBACK statement
• ROLLBACK TO SAVEPOINT statement
• SAVEPOINT statement
• Savepoints within transactions

Standards and compatibility