![ANSI_CLOSE_CURSORS_ON_ROLLBACK option [TSQL]](arrow-right.gif){kind=icon}
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” in Reference: Building Blocks, Tables, and Procedures
