This topic has not yet been rated - Rate this topic

AlterTableAddTableElementStatement.ExistingRowsCheckEnforcement Property

SQL Server 2012

Sets whether the data in the table is validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

public ConstraintEnforcement ExistingRowsCheckEnforcement { get; set; }

Property Value

Type: Microsoft.SqlServer.TransactSql.ScriptDom.ConstraintEnforcement
A value that represents the data in the table that is validated against a newly added or re-enabled FOREIGN KEY or CHECK constraint.

Reference

AlterTableAddTableElementStatement Class

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD