Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database tasks and features

Accessing database options

View and change database options to configure database behavior.


You can view and change the setting of persistent database options from SQL Central. Temporary UltraLite database options cannot be viewed or set from SQL Central.

Database options can be set or modified at any time. Temporary database options only persist while the database is running.

Option values are set by using the SET OPTION SQL statement.


  1. Using SQL Central, connect to the database.
  2. Right-click the database and click Options.
  3. To set or reset an option, type a new value in the Value field.
  4. Click Set Now or Reset Now to commit the change.


The database option setting is changed and saved.