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 specify an option in a SET OPTION statement.
Setting options for a database (Sybase Central)
Open the server.
Right-click the database and choose Options.
Edit the values.
Setting options for a database (SQL)
Specify the properties within a SET OPTION statement.
Tips
With the Database Options dialog, you can also set database options
for specific users and groups.
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.
See Chapter 2, “Database Options,” in Reference: Statements and Options.
