Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets the Boolean property value that specifies whether the view has a delete 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 HasDeleteTrigger As Boolean
Get
'Usage
Dim instance As View
Dim value As Boolean
value = instance.HasDeleteTrigger
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool HasDeleteTrigger { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasDeleteTrigger {
bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasDeleteTrigger : bool
function get HasDeleteTrigger () : boolean
Property Value
Type: System.Boolean
A Boolean value that specifies whether there are any delete triggers defined on the view.If True, there is a delete trigger defined on the view.If False (default), there is no delete trigger defined on the view.
Remarks
A delete trigger executes when a row of data is deleted.
Examples
Creating, Altering, and Removing Views
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace