Committing and Rolling Back Transactions
From InterBase
Go Up to Using Batch Updates to Submit Multiple Statements
Changes to the database from data definition (DDL) statements—for example, CREATE
and 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 INSERT
and 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.