The AllowNulls property exposes the ability of a data type to accept NULL as a value.
| Column Object | UserDefinedDatatype Object |
| SystemDatatype Object |
object.AllowNulls [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | True or False |
If True, the Microsoft® SQL Server™ data type or column referenced can accept NULL as a value.
If False, NULL is not allowed.
Set the AllowNulls property to set NULL as an accepted value for columns and user-defined data types.
Boolean
Read-only for SystemDatatype objects. Read/write for Column and UserDefinedDatatype objects.
HRESULT GetAllowNulls(LPBOOL pRetVal);
HRESULT SetAllowNulls(BOOL NewValue);