Show TOC

ROLLBACK StatementLocate this document in the navigation structure

Undoes any changes made since the last COMMIT or ROLLBACK.

Quick Links:

Go to Usage

Go to Standards

Go to Permissions

Syntax
ROLLBACK [ WORK ]
Usage

(back to top)

ROLLBACK ends a logical unit of work (transaction) and undoes all changes made to the database during this transaction. A transaction is the database work done between COMMIT or ROLLBACK statements on one database connection.

Side Effects

  • Closes all cursors not opened WITH HOLD.
  • Releases locks held by the transaction issuing the ROLLBACK.
Standards

(back to top)

  • SQL—ISO/ANSI SQL compliant.
  • SAP Database products—Supported by SAP ASE.
Permissions

(back to top)

None, but user must be connected to the database.
Related Information