• Article

Trigger.InsteadOf Property

Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation.

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

value = instance.InsteadOf

instance.InsteadOf = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool InsteadOf { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool InsteadOf {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member InsteadOf : bool with get, set

function get InsteadOf () : boolean
function set InsteadOf (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the trigger is executed instead of the insert, delete, or update operation.
If True, the trigger is executed instead of the insert, delete, or update operation.
If False (default), the trigger is executed as well as the insert, delete, or update operation.