ROLLBACK Statement

Undoes any changes made since the last COMMIT or ROLLBACK.

Quick Links:

Go to Usage

Go to Standards

Go to Permissions

Syntax

ROLLBACKWORK ]

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

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.
Related reference
COMMIT Statement
ROLLBACK TO SAVEPOINT Statement