ROLLBACK TO SAVEPOINT v17
Name
ROLLBACK TO SAVEPOINT
— Roll back to a savepoint.
Synopsis
Description
Roll back all commands that were executed after the savepoint was set. The savepoint remains valid and you can roll back to it again if you need to.
ROLLBACK TO SAVEPOINT
destroys all savepoints that were established after the named savepoint.
Parameters
savepoint_name
The savepoint to which to roll back.
Notes
Specifying a savepoint name that wasn't established is an error.
ROLLBACK TO SAVEPOINT
isn't supported in SPL programs.
Examples
Undo the effects of the commands executed from the point when savepoint depts
was established: