View.HasUpdateTrigger Property
Gets the Boolean property value that specifies whether the view has at least one update trigger.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasUpdateTrigger As Boolean
Get
'Usage
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
Property Value
Type: 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.
Remarks
An update trigger executes when a row of data is updated.
Examples
Creating, Altering, and Removing Views
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace