H2 Database - Rollback

ROLLBACK is a command from the SQL grammar used to roll back the transaction to a Savepoint or to the previous transaction. By using this command, we can either roll back to the specific Savepoint or we can roll back to the previous executed transaction.

Syntax

There are two different syntaxes for ROLLABCK command.

Following is the generic syntax for the rollback command.

ROLLBACK [ TO SAVEPOINT savepointName ] 

Following is the generic syntax of the Rollback command to the specific transaction.

ROLLBACK TRANSACTION transactionName 

Example 1

In this example, we will roll back the current transaction to a Savepoint named sp1_test using the following command.

ROLLBACK sp1_test; 

The above command produces the following output.

Rollback successfully 

Example 2

In the following example, we will roll back the complete transaction named tx_test using the given command.

ROLLBACK TRANSACTION tx_test;

The above command produces the following output.

Rollback successfully