|
Controls whether new columns that are created without specifying either NULL or NOT NULL are allowed to contain NULL values.
On, Off
On
| 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.