Aracılığıyla paylaş

Trigger.Delete Property

  • Makale

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

'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property Delete As Boolean
    Get
    Set
'Kullanım
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)

Property Value

Type: 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.

Examples

Creating, Altering, and Removing Triggers

See Also

Reference

Trigger Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

DML Triggers

CREATE TRIGGER (Transact-SQL)