Controls whether new columns that are created without specifying either NULL or NOT NULL are allowed to contain NULL values.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
The allow_nulls_by_default option is included for Transact-SQL compatibility.