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

SQL Anywhere 12.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help » SQL Anywhere properties windows


Database Options window

Any options you set in this window 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.

This window 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. When you select an option, the Value field is enabled.

  • Value   Choose an option in the Options list, and then type or select the setting in the Value field. You can make the setting permanent by clicking Set Permanent Now.

Once you select an option, you can use the buttons at the side of the window.

  • New   Displays the Create Public Option window. In this window, you can define new options and set their values.

  • Remove Now   Removes the selected option from the list.

  • Set Permanent Now   To change an option setting for the database permanently, select an option from the Options list, type the setting in the Value field, then click Set Permanent Now.

 See also