To cancel any changes made since a SAVEPOINT.
ROLLBACK TO SAVEPOINT [ savepoint-name ]
The ROLLBACK TO SAVEPOINT statement will undo any changes that have been made since the SAVEPOINT was established. Changes made prior to the SAVEPOINT are not undone; they are still pending.
The savepoint-name is an identifier that was specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is used. Any savepoints since the named savepoint are automatically released.
There must have been a corresponding SAVEPOINT within the current transaction.
None.
SQL/2003 SQL/foundation feature outside core SQL.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |