View.HasInsteadOfTrigger Property


Gets the Boolean property value that specifies whether the view has any instead of triggers.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

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

Property Value

Type: System.Boolean

A Boolean value that specifies whether there an any instead of triggers defined on the view.

If True, at least one of the view's triggers is defined as an instead of trigger.

If False (default), there are no instead of triggers defined on the view.

An instead of trigger runs instead of the triggering statement.

Return to top