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 Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

Alphabetical list of options Next Page

allow_nulls_by_default option [compatibility]

Controls whether new columns that are created without specifying either NULL or NOT NULL are allowed to contain NULL values.

Allowed values

On, Off



Off for Open Client and jConnect connections


The allow_nulls_by_default option is included for Transact-SQL compatibility. See Setting options for Transact-SQL compatibility.