Share via

AlterTableAddTableElementStatement.ExistingRowsCheckEnforcement Property

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Specifies whether the data in the table is or is not validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint. Defines which one of WITH CHECK or WITH NOCHECK were used. Check is the default for this class(if nothing was explicitly mentioned), since these are new constraints (Books online).

public Microsoft.SqlServer.TransactSql.ScriptDom.ConstraintEnforcement ExistingRowsCheckEnforcement { get; set; }
member this.ExistingRowsCheckEnforcement : Microsoft.SqlServer.TransactSql.ScriptDom.ConstraintEnforcement with get, set
Public Property ExistingRowsCheckEnforcement As ConstraintEnforcement

Property Value

ConstraintEnforcement

Applies to