Freigeben über


Trigger.DeleteOrder-Eigenschaft

Gets or sets the order in which the trigger and the delete operation are executed.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property DeleteOrder As ActivationOrder 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As ActivationOrder 

value = instance.DeleteOrder

instance.DeleteOrder = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public ActivationOrder DeleteOrder { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property ActivationOrder DeleteOrder {
    ActivationOrder get ();
    void set (ActivationOrder value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member DeleteOrder : ActivationOrder with get, set
function get DeleteOrder () : ActivationOrder 
function set DeleteOrder (value : ActivationOrder)

Eigenschaftswert

Typ: Microsoft.SqlServer.Management.Smo.Agent.ActivationOrder
An ActivationOrder object value that specifies whether the trigger is executed before or after the records are deleted.

Beispiele

Erstellen, Ändern und Löschen von Trigger

Siehe auch

Verweis

Trigger Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

DML-Trigger

CREATE TRIGGER (Transact-SQL)