Accessing database options

View and change database options to configure database behavior.

Context

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.

Procedure

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

Results

The database option setting is changed and saved.