Share via

  • Article

Table.HasInsteadOfTrigger Property

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

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

Syntax

'Declaration
<SfcPropertyAttribute> _
Public ReadOnly Property HasInsteadOfTrigger As Boolean
    Get
'Usage
Dim instance As Table
Dim value As Boolean

value = instance.HasInsteadOfTrigger

[SfcPropertyAttribute]
public bool HasInsteadOfTrigger { get; }

[SfcPropertyAttribute]
public:
property bool HasInsteadOfTrigger {
    bool get ();
}

[<SfcPropertyAttribute>]
member HasInsteadOfTrigger : bool

function get HasInsteadOfTrigger () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether there are any instead of triggers defined on the table.
If True, at least one of the table's triggers is defined as an instead of trigger. Otherwise, False (default).

Remarks

An "instead of" trigger runs instead of the triggering statement.