Trigger.MarkForDrop Method

Marks the trigger to be dropped.

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 Trigger 
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 to drop the trigger next time the Alter method is run on the parent object.If True, the trigger is dropped when the Alter method of the parent object is run.If False, the trigger is not dropped on alter.

Implements

IMarkForDrop.MarkForDrop(Boolean)

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)