Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database.AnsiNullDefault Property

 

Applies To: SQL Server 2016 Preview

Gets or sets a value that specifies whether the ANSI_NULL_DEFAULT database option is active.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design | SfcPropertyFlags.Matrix)]
public bool AnsiNullDefault { get; set; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the AnsiNullDefault database option is active. If True, user-defined data types default to allowing NULL values. Otherwise, False (default).

Return to top
Show:
© 2015 Microsoft