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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statement reference


UltraLite SET OPTION statement

Use this statement to change the values of database options.

SET OPTION option-name=option-value
option-name: identifier 
option-value: string, identifier, or number

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

You cannot specify whether and option is persistent or not. The way an option has been implemented in UltraLite determines whether it is a persistent or temporary option. Persistent options are stored in the sysuldata table. Temporary options are used only until the database stops running.

See also

The following statement sets the global_database_id option to 100:

SET OPTION global_database_id=100;