Setting Database Options in Interactive SQL

Database options are configurable settings that change the way the database behaves or performs.

Specify the properties within a SET OPTION statement.
Note: 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.