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

Setting database options

Database options are configurable settings that change the way the database behaves or performs. In Sybase Central, all of these options are grouped together in the Database Options dialog. In Interactive SQL, you can change an option setting using a SET OPTION statement.

To set options for a database (Sybase Central)

1. Open the desired server.

2. Right-click the desired database and choose Options from the popup menu.

3. Edit the desired values.

To set the options for a database (SQL)

• Specify the desired values within a SET OPTION statement.

Tips With the Database Options dialog, you can also set database options for specific users and groups (when you open this dialog for a user or group, it is called the User Options dialog or Group Options dialog, respectively). When you set options for the database itself, you are actually setting options for the PUBLIC group in that database because all users and groups inherit option settings from PUBLIC.

For more information about options, see Introduction to database options.