H2 Database - Savepoint
SAVEPOINT is a command used to temporarily save a transaction. It is better to store savepoints in your transaction as it is useful to rollback a transaction to the appropriate savepoint if necessary.
Following is the general syntax of the Savepoint command.
In this example, we will create a savepoint named Half_Done using the following command.
SAVEPOINT Half_Done ;
The above command produces the following output.