---
title: "ROLLBACK"
id: sql-rollback
pg_version: "20devel"
---

<a id="sql-rollback"></a>

# ROLLBACK — abort the current transaction

## Synopsis

```
ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
```

<a id="id-1.9.3.171.5"></a>

## Description

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

<a id="id-1.9.3.171.6"></a>

## Parameters

<a id="sql-rollback-transaction"></a>

**`WORK`**, **`TRANSACTION`**

 Optional key words. They have no effect. <a id="sql-rollback-chain"></a>

**`AND CHAIN`**

 If `AND CHAIN` is specified, a new (not aborted) transaction is immediately started with the same transaction characteristics (see [SET TRANSACTION](sql-set-transaction.md)) as the just finished one. Otherwise, no new transaction is started. <a id="id-1.9.3.171.7"></a>

## Notes

Use [`COMMIT`](sql-commit.md) to successfully terminate a transaction. 

Issuing `ROLLBACK` outside of a transaction block emits a warning and otherwise has no effect. `ROLLBACK AND CHAIN` outside of a transaction block is an error. 

<a id="id-1.9.3.171.8"></a>

## Examples

To abort all changes: 
ROLLBACK;


<a id="id-1.9.3.171.9"></a>

## Compatibility

The command `ROLLBACK` conforms to the SQL standard. The form `ROLLBACK TRANSACTION` is a PostgreSQL extension. 

<a id="id-1.9.3.171.10"></a>

## See Also

[BEGIN](sql-begin.md), [COMMIT](sql-commit.md), [ROLLBACK TO SAVEPOINT](sql-rollback-to.md)