10.1.5. RELEASE SAVEPOINT

Used for

Erasing a savepoint

Available

DSQL

Syntax

  1. RELEASE SAVEPOINT sp_name [ONLY]
Table 175. RELEASE SAVEPOINT Statement Parameter
ParameterDescription

sp_name

Savepoint name. Available only in DSQL

The statement RELEASE SAVEPOINT erases a named savepoint, freeing up all the resources it encompasses. By default, all the savepoints created after the named savepoint are released as well. The qualifier ONLY directs the engine to release only the named savepoint.

See also

SAVEPOINT