Controls whether new columns created without specifying either NULL or NOT NULL are allowed to contain NULL values.
ON, OFF
ON
OFF for Open Client and JDBC connections
The ALLOW_NULLS_BY_DEFAULT option is included for Transact-SQL compatibility.
Appendix A, “Compatibility with Other Sybase Databases.”