RELEASE SAVEPOINT

RELEASE SAVEPOINT — destroy a previously defined savepoint

Syntax

RELEASE SAVEPONT savepoint_name 

Description

Releases a savepoint. See SAVEPOINT.

Parameters

Example:

Create and release a savepoint.

AUTOCOMMIT off;
CREATE TABLE t1 (f1 INTEGER);
START TRANSACTION;
INSERT INTO t1 VALUES (1);
SAVEPOINT s1;
INSERT INTO t1 VALUES (2);
RELEASE SAVEPOINT s1;
SELECT * FROM t1;
 F1 
 ---
  1 
  2 
COMMIT; 
 
/* Error generated if savepoint does not exit */
RELEASE SAVEPOINT s1;
savepoint "S1" is not defined