ColumnsNullByDefault Property (SQL-DMO)

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]

Part Description
object Expression that evaluates to an object in the Applies To list
value True or False

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.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetColumnsNullByDefault(LPBOOL pRetVal);

HRESULT SetColumnsNullByDefault(BOOL NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.