共用方式為


View.HasUpdateTrigger 屬性

Gets the Boolean property value that specifies whether the view has at least one update trigger.

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasUpdateTrigger As Boolean 
    Get
'用途
Dim instance As View 
Dim value As Boolean 

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

屬性值

型別:System.Boolean
A Boolean value that specifies whether there is an update trigger defined on the view.If True, there is an update trigger defined on the view.If False (default), there is no update trigger defined on the view.

備註

An update trigger executes when a row of data is updated.

範例

建立、改變和移除檢視

請參閱

參考

View 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

設計和實作檢視

CREATE VIEW (Transact-SQL)