ROLLBACK Statement

Undoes any changes made since the last COMMIT or ROLLBACK.

Quick Links:

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 Sybase Database product—Supported by Adaptive Server.

Permissions

(back to top)

None, but user must be connected to the database.