Aracılığıyla paylaş


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)

Syntax

'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasInsteadOfTrigger As Boolean
    Get
'Kullanım
Dim instance As View
Dim value As Boolean

value = instance.HasInsteadOfTrigger
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasInsteadOfTrigger { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasInsteadOfTrigger {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasInsteadOfTrigger : bool
function get HasInsteadOfTrigger () : boolean

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.

Remarks

An instead of trigger runs instead of the triggering statement.

Examples

Creating, Altering, and Removing Views

See Also

Reference

View Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Designing and Implementing Views

CREATE VIEW (Transact-SQL)