Partager via


Propriété View.HasDeleteTrigger

Gets the Boolean property value that specifies whether the view has a delete trigger.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property HasDeleteTrigger As Boolean 
    Get
'Utilisation
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

Valeur de propriété

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.

Notes

A delete trigger executes when a row of data is deleted.

Exemples

Création, modification et suppression de vues

Voir aussi

Référence

View Classe

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Conception et mise en œuvre de vues

CREATE VIEW (Transact-SQL)