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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to dialog boxes

Create Trigger Condition dialog Next Page

Database Options dialog

Any options you set in this dialog are set for the PUBLIC group. Changing the value of an option for the PUBLIC group sets the value of the option for all users who have not set their own value. An option value cannot be set for an individual user ID unless there is already a PUBLIC group setting for that option.


When you change options, some of the settings take effect immediately, while for others to take effect, you must restart the database.

The Database Options dialog has the following components:

Database    Displays the name of the selected database.

Show    Provides a list of option types. For example, if you choose Database Options, only database-related options appear in the Options list.

Options list    Shows the option settings and default values based on the type of options selected in the Show list. Once you select an option, you can use the buttons at the side of the dialog.

Value    Select an option in the Options list and type the desired setting in the Value field. You can make the setting temporary or permanent by clicking Set Temporary Now and Set Permanent Now respectively.

See Alphabetical list of options.

See also