H2 Database - Savepoint
H2 Database - Savepoint
SAVEPOINT is a command used to temporarily save the transaction. It is better to maintain savepoints in your transaction as it is helpful to roll back the transaction to the respective Savepoint whenever necessary.
Syntax
Following is the generic syntax of the Savepoint command.
SAVEPOINT savepointName
Example
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.
Savepoint created
Frequently Asked Questions
+
Ans: H2 Database - Grant view more..
+
Ans: H2 Database - Commit view more..
+
Ans: H2 Database - Truncate view more..
+
Ans: H2 Database - Savepoint view more..
+
Ans: H2 Database - Rollback view more..
+
Ans: H2 Database - JDBC Connection view more..
Recommended Posts:
- H2 Database Tutorial
- H2 Database - Introduction
- H2 Database - Installation
- H2 Database - Select
- H2 Database - Insert
- H2 Database - Update
- H2 Database - Delete
- H2 Database - Backup
- H2 Database - Call
- H2 Database - Explain
- H2 Database - Merge
- H2 Database - Show
- H2 Database - Create
- H2 Database - Alter
- H2 Database - Drop
Rating - NAN/5
Advertisements