Share via


Trigger.Delete-Eigenschaft

Gets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table.

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 Delete As Boolean 
    Get 
    Set
'Usage
Dim instance As Trigger 
Dim value As Boolean 

value = instance.Delete

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

Eigenschaftswert

Typ: System.Boolean
A Boolean value that specifies whether the trigger is executed when records are deleted.If True, the trigger is executed when records are deleted.If False (delete), the trigger is not executed when 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)