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)]
public bool InsteadOf { get; set; }

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.

Return to top
Show: