Export (0) Print
Expand All

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)

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

Property Value

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

Community Additions

ADD
Show:
© 2014 Microsoft