Rolling Back to a Savepoint

Note: You can only roll back the current transaction to a selected savepoint when manual commit mode is enabled.

Perform the following steps to roll back the current transaction to a selected savepoint:

  1. Right-click the Analyze Query window and click Rollback to savepoint.

    The Rollback to Savepoint dialog box appears.

  2. Type the desired name in the Savepoint Name box, and click OK.

    A message is displayed indicating that the transaction was rolled back to the savepoint.