8. SQL Statements : ROLLBACK : Description
 
Share this page                  
Description
The ROLLBACK statement aborts part or all of the current transaction.
Only the ROLLBACK statement without the optional TO clause can be used in database procedures, and only in procedures that are directly executed. A database procedure that is invoked by a rule cannot contain either version of the ROLLBACK statement.
If a database event registration is removed (using the REMOVE DBEVENT statement), and the transaction is subsequently rolled backed, the database event registration is not restored.