ROLLBACK

Use the ROLLBACK command to abort the current transaction and roll back all changes it has made so far.

Syntax

Syntax for rolling back the current transaction:

ROLLBACK [ WORK | TRANSACTION ]

The ROLLBACK command takes the following inputs:

Table 1. ROLLBACK input
Input	Description
WORK	These are optional keywords that have no effect.
TRANSACTION	These are optional keywords that have no effect.

The ROLLBACK command has the following outputs:

Table 2. ROLLBACK outputs
Output	Description
`ABORT`	The command was successful.
`NOTICE: rollback: no transaction in progress`	There is no transaction in progress.

You do not need any special privileges to issue this command.

The following provides sample usage.

Abort the current transaction and roll back all changes it has made so far:
```
MYDB.SCH1(USER)=> ROLLBACK WORK;
```