共用方式為


View.HasInsteadOfTrigger 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasInsteadOfTrigger As Boolean 
    Get
'用途
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

屬性值

型別: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.

範例

建立、改變和移除檢視

請參閱

參考

View 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

設計和實作檢視

CREATE VIEW (Transact-SQL)