Compartilhar via


Método Trigger.MarkForDrop

Marks the trigger to be dropped.

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

Sintaxe

'Declaração
Public Sub MarkForDrop ( _
    dropOnAlter As Boolean _
)
'Uso
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
)

Parâmetros

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

Implementa

IMarkForDrop.MarkForDrop(Boolean)

Exemplos

Criando, alterando e removendo gatilhos

Consulte também

Referência

Trigger Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Gatilhos DML

CREATE TRIGGER (Transact-SQL)