Export (0) Print
Expand All

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|SfcPropertyFlags.Matrix)]
public bool HasInsteadOfTrigger { get; }

Property Value

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft