ROLLBACK [ WORK ]

A transaction is the logical unit of work done on one database connection to a database between COMMIT or ROLLBACK statements. The ROLLBACK statement ends the current transaction and undoes all changes made to the database since the previous COMMIT or ROLLBACK.

In Interactive SQL, you can also execute a ROLLBACK by:

In Interactive SQL, executing a ROLLBACK from the SQL menu or the keyboard shortcut does not modify the contents of the SQL Statements pane; however, the Results tab in the Results pane is cleared.

None.

Closes all cursors not opened WITH HOLD.

• COMMIT statement
• Executing COMMIT and ROLLBACK statements in Interactive SQL
• ROLLBACK TO SAVEPOINT statement
• Interactive SQL options
• Cancellation of changes