This topic has not yet been rated - Rate this topic

AlterTableConstraintModificationStatement.ExistingRowsCheckEnforcement Property

SQL Server 2012

Gets or 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

'Declaration
Public Property ExistingRowsCheckEnforcement As ConstraintEnforcement 
	Get 
	Set
'Usage
Dim instance As AlterTableConstraintModificationStatement 
Dim value As ConstraintEnforcement 

value = instance.ExistingRowsCheckEnforcement

instance.ExistingRowsCheckEnforcement = value

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

AlterTableConstraintModificationStatement 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