View.HasAfterTrigger Property

Articolo
12/15/2008

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

Spazio dei nomi: Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintassi

'Dichiarazione
Public ReadOnly Property HasAfterTrigger As Boolean

public bool HasAfterTrigger { get; }

public:
property bool HasAfterTrigger {
    bool get ();
}

/** @property */
public boolean get_HasAfterTrigger ()

public function get HasAfterTrigger () : boolean

Valore proprietà

A Boolean value that specifies whether there an any after triggers defined on the view. If True, at least one of the view's triggers is defined as an after trigger. If False (default), there are no after triggers defined on the view.

Osservazioni

An after trigger runs on successful completion of the triggering statement. All referential cascade actions and constraint checks also must succeed before this trigger executes.

Esempio

How to: Create, Alter, and Remove a View in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

View Class
View Members
Microsoft.SqlServer.Management.Smo Namespace

Altre risorse

Progettazione e implementazione di viste
Creating, Altering, and Removing Views
CREATE VIEW (Transact-SQL)

Condividi tramite