ASA Database Administration Guide

Database Options

Alphabetical list of options

ALLOW_NULLS_BY_DEFAULT option [compatibility]

Function 

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

Allowed values 

ON, OFF

Default 

ON

OFF for Open Client and JDBC connections

Description 

The ALLOW_NULLS_BY_DEFAULT option is included for Transact-SQL compatibility.

For more information, see Setting options for Transact-SQL compatibility.

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.