AlterTableAddTableElementStatement.ExistingRowsCheckEnforcement Property

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.Data.Schema.ScriptDom.Sql
Assembly:  Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)

Syntax

'Declaration
Public Property ExistingRowsCheckEnforcement As ConstraintEnforcement
public ConstraintEnforcement ExistingRowsCheckEnforcement { get; set; }
public:
property ConstraintEnforcement ExistingRowsCheckEnforcement {
    ConstraintEnforcement get ();
    void set (ConstraintEnforcement value);
}
member ExistingRowsCheckEnforcement : ConstraintEnforcement with get, set
function get ExistingRowsCheckEnforcement () : ConstraintEnforcement
function set ExistingRowsCheckEnforcement (value : ConstraintEnforcement)

Property Value

Type: Microsoft.Data.Schema.ScriptDom.Sql.ConstraintEnforcement
Returns a ConstraintEnforcement enumeration value.

Remarks

Defines whether WITH CHECK or WITH NOCHECK was used. Check is the default for this class (if nothing was explicitly mentioned), since these are new constraints.

.NET Framework Security

See Also

Reference

AlterTableAddTableElementStatement Class

Microsoft.Data.Schema.ScriptDom.Sql Namespace