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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Statement Reference

FROM clause Next Page

UltraLite SET OPTION statement


Use this statement to change the values of database options.

Syntax

SET OPTION option-name=option-value

option-name: identifier

option-value: string, identifier, or number

Remarks

You can only set database options with this statement. Properties cannot be modified after the database has been created.

In UltraLite, you cannot specify whether an option is persistent or not. The way the option has been implemented in UltraLite determines whether the option is a temporary or persistent option. Only persistent options are stored in the database in the sysuldata table. Temporary options only are used by UltraLite until the database stops running.

See also
Example

The following sets the global_database_id option to 100:

SET OPTION global_database_id=100