Freigeben über


Check.MarkForDrop-Methode

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

'Declaration
Public Sub MarkForDrop ( _
    dropOnAlter As Boolean _
)
'Usage
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
)

Parameter

  • dropOnAlter
    Typ: 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.

Implementiert

IMarkForDrop.MarkForDrop(Boolean)

Hinweise

HinweisHinweis

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

Beispiele

Aufrufen von Methoden

Siehe auch

Verweis

Check Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Arbeiten mit Datenbankobjekten

CHECK-Einschränkungen

CREATE TABLE (Transact-SQL)