ALLOW_NULLS_BY_DEFAULT option [TSQL]

Function

Controls whether new columns 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.

See also

Appendix A, “Compatibility with Other Sybase Databases.”