English

ROLLBACK

Abort the current transaction.

Synopsis

ROLLBACK [WORK | TRANSACTION]

ROLLBACK rolls back the current transaction and causes all updates made by the transaction to be discarded.

WORK

TRANSACTION

Use COMMIT to successfully submit the current transaction.

If not inside the transaction, issuing ROLLBACK will not cause any harm, but will trigger a warning message.

To discard all changes in the current transaction:

ROLLBACK;

The SQL standard specifies only two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command fully meets the requirements.