ABORT

Function

ABORT rolls back the current transaction and cancels the changes in the transaction.

This command is equivalent to ROLLBACK, and is present only for historical reasons. Now ROLLBACK is recommended.

Precautions

ABORT has no impact outside a transaction, but will provoke a warning.

Syntax

1

ABORT [ WORK | TRANSACTION ] ;

Parameter Description

WORK | TRANSACTION

Optional keyword has no effect except increasing readability.

Examples

Abort a transaction. Performed update operations will be undone.

1

ABORT; 

Helpful Links

SET TRANSACTION, COMMIT | END, ROLLBACK