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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database tasks and features

 

Accessing database options

View and change database options to configure database behavior.

Prerequisites

There are no prerequisites for this task.

Context and remarks

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.

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.

 Task
  1. Using Sybase 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.

Results

The database option setting is changed and saved.

 See also