Dela via


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
'Usage
Dim instance As AlterTableAddTableElementStatement 
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. 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

AlterTableAddTableElementStatement Members

Microsoft.Data.Schema.ScriptDom.Sql Namespace