SQL-DMO
AllowNulls Property
The AllowNulls property exposes the ability of a data type to accept NULL as a value.
Applies To
| Column Object | UserDefinedDatatype Object |
| SystemDatatype Object |
Syntax
object.AllowNulls [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read-only for SystemDatatype objects. Read/write for Column and UserDefinedDatatype objects.
Prototype (C/C++)
HRESULT GetAllowNulls(LPBOOL pRetVal);
HRESULT SetAllowNulls(BOOL NewValue);
Remarks
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.