H2 Database Tutorial
H2 Database - Data Manipulation
H2 Database - Data Definition
H2 Database Useful Resources
Selected Reading
H2 Database - Data Manipulation
- H2 Database - Show
- H2 Database - Merge
- H2 Database - Explain
- H2 Database - Call
- H2 Database - Backup
- H2 Database - Delete
- H2 Database - Update
- H2 Database - Insert
- H2 Database - Select
H2 Database - Data Definition
- H2 Database - JDBC Connection
- H2 Database - Rollback
- H2 Database - Savepoint
- H2 Database - Grant
- H2 Database - Commit
- H2 Database - Truncate
- H2 Database - Drop
- H2 Database - Alter
- H2 Database - Create
H2 Database Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
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 createdAdvertisements