ROLLBACK

    Description

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

    WORK

    Optional key words. They have no effect.

    Notes

    Use COMMIT to successfully end the current transaction.

    To discard all changes made in the current transaction:

    1. ROLLBACK;

    Compatibility

    The SQL standard only specifies the two forms and ROLLBACK WORK. Otherwise, this command is fully conforming.

    Parent topic: