Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Properties (SQL-DMO)
C (SQL-DMO Properties)
CaseSensitive Property
Catalog Property
Category Property
CentralizedConflicts Property
CharacterSet Property
Checked Property
CheckPermissions Property
Clustered Property
CmdExecSuccessCode Property
CodePage Property
Collation Property
CollationName Property
ColumnDelimiter Property
ColumnMaxLength Property
ColumnName Property
Columns Property
ColumnsNullByDefault Property
ColumnTracking Property
ColumnType Property
Command Property
CommandOptions Property
CommandTerminator Property
CompareNull Property
CompatibilityLevel Property (Database)
CompatibilityLevel Property (MergePublication2, TransPublication2)
ComputedText Property
ConflictPolicy Property
ConflictRetention Property
ConflictTable Property
ConnectionID Property
ConnectTimeout Property
ContactNull Property
CopyAllDefaults Property
CopyAllFunctions Property
CopyAllObjects Property
CopyAllRules Property
CopyAllStoredProcedures Property
CopyAllTables Property
CopyAllTriggers Property
CopyAllUserDefinedDatatypes Property
CopyAllViews Property
CopyData Property
CopySchema Property
CountResetDate Property
CreateDate Property
CreateForAttach Property
CreationScriptOptions Property
CreationScriptPath Property
CurrentCompatibility Property
CurrentExecutionStatus Property
CurrentResultSet Property
CurrentRunRetryAttempt Property
CurrentRunStatus Property
CurrentRunStep Property
CurrentValue Property
CursorCloseOnCommit Property
Count Property
CountResetTime Property
Expand Minimize
This topic has not yet been rated - Rate this topic

ColumnsNullByDefault Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Copy 

object
.ColumnsNullByDefault [=value]
object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

Copy 
HRESULT GetColumnsNullByDefault(LPBOOL pRetVal);
HRESULT SetColumnsNullByDefault(BOOL NewValue);

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.