Dela via


AlterTableConstraintModificationStatement.ExistingRowsCheckEnforcement Property

Gets or sets whether the data in the table is or is not 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
'Usage
Dim instance As AlterTableConstraintModificationStatement 
Dim value As ConstraintEnforcement 

value = instance.ExistingRowsCheckEnforcement

instance.ExistingRowsCheckEnforcement = value
public ConstraintEnforcement ExistingRowsCheckEnforcement { get; set; }
public:
property ConstraintEnforcement ExistingRowsCheckEnforcement {
    ConstraintEnforcement get ();
    void set (ConstraintEnforcement value);
}
public function get ExistingRowsCheckEnforcement () : ConstraintEnforcement 
public function set ExistingRowsCheckEnforcement (value : ConstraintEnforcement)

Property Value

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

Remarks

Defines which of WITH CHECK or WITH NOCHECK was used. NoCheck is the default for this class (if nothing was explicitly mentioned), since these are reenabled constraints.

.NET Framework Security

See Also

Reference

AlterTableConstraintModificationStatement Class

AlterTableConstraintModificationStatement Members

Microsoft.Data.Schema.ScriptDom.Sql Namespace