Accessing database options

Options are used to configure database behavior. 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. For example, the following statement sets the global_database_id option to 100: 

SET OPTION global_database_id=100;
 Browse or modify persistent UltraLite database options (Sybase Central)

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

  1. Connect to the database.

  2. Right-click the database and click Options.

  3. If you want 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.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1