This topic has not yet been rated - Rate this topic

AlterTableConstraintModificationStatement.ConstraintEnforcement Property

SQL Server 2012

Sets whether the constraint is enabled or disabled. When disabled, future inserts or updates to the column are not validated against the constraint conditions.

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

Syntax

C++

JScript

public ConstraintEnforcement ConstraintEnforcement { get; set; }

Property Value

Type: Microsoft.SqlServer.TransactSql.ScriptDom.ConstraintEnforcement
Returns a ConstraintEnforcement enumeration value.

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