Making changes permanent

First Guide to SQL Anywhere Studio
PART 3. Basic SQL
CHAPTER 15. Updating the Database

Making changes permanent

The SQL statement

COMMIT

makes all changes permanent.

Use COMMIT with care
When trying the examples in this tutorial, be careful not to COMMIT any changes until you are sure that you want to change the database permanently.

Making changes permanent in Interactive SQL

The default action in Interactive SQL is to do a COMMIT on exit. This can be controlled with the Interactive SQL option COMMIT_ON_EXIT.

For Info For more information on Interactive SQL options, see Interactive SQL options.

Interactive SQL has another option, named AUTO_COMMIT. If this option is on, Interactive SQL does a COMMIT operation after every command. The default for this option is OFF. Usually you will want it OFF, giving you the opportunity to ROLLBACK the changes (if, for example, an update or delete operation doesn't produce the intended results).