共用方式為


Trigger.DeleteOrder 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property DeleteOrder As ActivationOrder 
    Get 
    Set
'用途
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)

屬性值

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

範例

建立、改變和移除觸發程式

請參閱

參考

Trigger 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

DML 觸發程序

CREATE TRIGGER (Transact-SQL)