Committing and Rolling Back Transactions
Changes to the database from data definition (DDL) statements—for example,
ALTER statements—are automatically committed by default. To turn off automatic commit of DDL, choose Edit|Options and set the Auto Commit DDL option to false in the SQL Options dialog.
Changes made to the database by data manipulation (DML) statements—for example
UPDATE—are not permanent until they are committed. Commit changes by choosing Transactions|Commit or by clicking Commit on the toolbar.
To undo all database changes from DML statements since the last commit, choose Transactions|Rollback or click Rollback on the toolbar.