ColumnsNullByDefault Property

SQL-DMO

SQL-DMO

ColumnsNullByDefault Property

The ColumnsNullByDefault property controls column default value behavior when a table is created in the Microsoft® SQL Server™ database.

Applies To
DBOption Object
Syntax

object.ColumnsNullByDefault [= value]

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetColumnsNullByDefault(LPBOOL pRetVal);

HRESULT SetColumnsNullByDefault(BOOL NewValue);

Remarks

If TRUE, columns in new tables allow NULL.

If FALSE, columns in new tables do not allow NULL.

The default behavior can be changed on a column-by-column basis. For more information, see AllowNulls Property.