SAVEPOINT Statement

Establishes a savepoint within the current transaction.

Quick Links:

Syntax

SAVEPOINT [ savepoint-name ]

Parameters

(back to top)

savepoint-name – an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement.

Usage

(back to top)

All savepoints are automatically released when a transaction ends.

Savepoints that are established while a trigger is executing or while an atomic compound statement is executing are automatically released when the atomic operation ends.

Standards

(back to top)

SQL—Vendor extension to ISO/ANSI SQL grammar.
SAP Sybase Database product—Not supported in Adaptive Server. To implement similar features in an Adaptive Server-compatible manner, use nested transactions.

Permissions

(back to top)

None