ROLLBACK(l)                                           ROLLBACK(l)

NAME
       ROLLBACK - Aborts the current transaction

SYNOPSIS
       ROLLBACK [ WORK | TRANSACTION ]

   INPUTS
       None.

   OUTPUTS
       ABORT  Message returned if successful.

       NOTICE: UserAbortTransactionBlock and not in in-progress
              state
              If  there  is  not  any  transaction  currently  in
              progress.

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

   NOTES
       The keywords WORK and TRANSACTION are  noise  and  can  be
       omitted.

       Use  commit(l)  to  successfully  terminate a transaction.
       abort(l) is a synonym for ROLLBACK.

USAGE
       To abort all changes:

       ROLLBACK WORK;

COMPATIBILITY
   SQL92
       Full compatibility. The TRANSACTION keyword is a  Postgres
       extension.

SQL - Language Statements 15 August 1999                        1