ROLLBACK [ WORK ]

Using UltraLite SQL creates a transaction. A transaction consists of all changes (INSERTs, UPDATEs, and DELETEs) since the last ROLLBACK or COMMIT. The ROLLBACK statement ends the current transaction and undoes all changes made to the database since the previous COMMIT or ROLLBACK.

• COMMIT statement [UltraLite]

The following statement rolls the database back to the state it was in at the previous commit:

ROLLBACK;