Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

SAVEPOINT statement

Establishes a savepoint within the current transaction.

SAVEPOINT [ savepoint-name ]

Establish a savepoint within the current transaction. The savepoint-name is an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement. All savepoints are automatically released when a transaction ends.

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

You cannot modify data in a proxy table from within a savepoint.



Side effects


  • ANSI/ISO SQL Standard

    The SAVEPOINT statement is part of optional ANSI/ISO SQL Language Feature T271, "Savepoints".

  • Transact-SQL

    In Transact-SQL, creating a savepoint is accomplished with the SAVE TRANSACTION statement.