Aracılığıyla paylaş


Check.MarkForDrop Method

Marks the foreign key to be dropped next time its parent Table object is altered by the Alter method.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Bildirim
Public Sub MarkForDrop ( _
    dropOnAlter As Boolean _
)
'Kullanım
Dim instance As Check
Dim dropOnAlter As Boolean

instance.MarkForDrop(dropOnAlter)
public void MarkForDrop(
    bool dropOnAlter
)
public:
virtual void MarkForDrop(
    bool dropOnAlter
) sealed
abstract MarkForDrop : 
        dropOnAlter:bool -> unit 
override MarkForDrop : 
        dropOnAlter:bool -> unit 
public final function MarkForDrop(
    dropOnAlter : boolean
)

Parameters

  • dropOnAlter
    Type: System.Boolean
    A Boolean value that specifies whether the check constraint is dropped when an Alter method is run on the parent SqlSmoObject object.
    If True, the check constraint is dropped when the table is altered.
    If False, the check constraint is not marked for drop.

Implements

IMarkForDrop.MarkForDrop(Boolean)

Remarks

Not

For check constraints based on the UserDefinedTableType object this method generates an exception because user-defined data types cannot be modified.

Examples

Calling Methods

See Also

Reference

Check Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

CHECK Constraints

CREATE TABLE (Transact-SQL)