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

This keyword is optional and does not affect the ABORT operation.

Examples

Abort a transaction. Performed update operations will be undone.

1

ABORT; 

Helpful Links

SET TRANSACTION, COMMIT | END, ROLLBACK