Skip to main content

ABORT

Terminates the current transaction.

Syntax​


    ABORT [WORK | TRANSACTION] [AND CHAIN | AND NO CHAIN]

Description​

ABORT rolls back the current transaction and causes all updates made by the transaction to be discarded. It has the same effect as ROLLBACK.

note

ABORT is presented only for historical reasons.

Parameters​

  • [WORK | TRANSACTION]

    An additional keyword that has no effect.

  • [AND CHAIN | AND NO CHAIN]

    Whether to start a transaction with the same characteristics immediately after the current transaction is aborted. Supported options include:

    • AND CHAIN: specifies yes.
    • AND NO CHAIN: specifies no and is the default.

Examples​

Roll back the current transaction without saving any changes made by it:

ABORT;

SQL standard compatibility​

ABORT is a Relyt extension and is equivalent to standard SQL command ROLLBACK.