ROLLBACK(SQL)

A ROLLBACK statement in SQL ends a transaction within a relational database management system (RDBMS) and reverts any work done since the BEGIN WORK statement was issued.

The general format is to issue a BEGIN WORK statement, one or more SQL statements, and then the ROLLBACK statement. Alternatively, a COMMMIT statement can be issued, which commits all changes made and makes them viewable by other users.

A ROLLBACK statement will also release any existing savepoints that may be in use.