SqlDeploymentOptions.GenerateSmartDefaults Property

Definition

Get boolean that specifies whether default values should be generated to populate NULL columns that are constrained to NOT NULL values.

C#
public bool GenerateSmartDefaults { get; }

Property Value

True if default values should be generated; otherwise false. Default is false.

Remarks

This is useful when needing to add a new NOT NULL column to an existing table with data.

Applies to

Product Versions
Microsoft.SQLServer.DacFx 140.3881.1, 150.18208.0, 160.2004021.0, 161.6374.0, 162.2.111