System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Savepoint Statement
Was this helpful?
Savepoint Statement
Declares a named savepoint marker within a transaction. Savepoints can be used in conjunction with the Rollback Statement to roll back a transaction to the specified savepoint when necessary. Using savepoints can eliminate the need to roll back an entire transaction if it is not necessary.
Note:  This statement has additional considerations when used in a distributed environment. For more information, see the Ingres Star User Guide.
Syntax:
savepoint savepoint_name;
Last modified date: 12/20/2023