Partager via

Classe TableEventSet

  • Article

The TableEventSet object represents a set of table events.

Hiérarchie d'héritage

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.TableEventSet

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

Syntaxe

'Déclaration
Public NotInheritable Class TableEventSet _
    Inherits EventSetBase
'Utilisation
Dim instance As TableEventSet

public sealed class TableEventSet : EventSetBase

public ref class TableEventSet sealed : public EventSetBase

[<SealedAttribute>]
type TableEventSet =  
    class 
        inherit EventSetBase 
    end

public final class TableEventSet extends EventSetBase

Le type TableEventSet expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique TableEventSet() Initializes a new instance of the TableEventSet class.
Méthode publique TableEventSet(TableEvent) Initializes a new instance of the TableEventSet class with a specified event.
Méthode publique TableEventSet(array<TableEvent[]) Initializes a new instance of the TableEventSet class with a specified set of events.
Méthode publique TableEventSet(TableEventSet) Initializes a new instance of the TableEventSet class with a specified set of events.

Haut de la page

Propriétés

  Nom Description
Propriété publique AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event that occurs when the Full-Text Index is altered or created is included in the event set.
Propriété publique AlterIndex Gets or sets a Boolean property value that specifies whether the event that occurs when an index is altered is included in the event set.
Propriété publique AlterTable Gets or sets a Boolean property value that specifies whether the event that occurs when a table is altered is included in the event set.
Propriété publique CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event that occurs when a Full-Text Index is created is included in the event set.
Propriété publique CreateIndex Gets or sets a Boolean property value that specifies whether the event that occurs when an index is created is included in the event set.
Propriété publique CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event that occurs when a Spatial Index is created is included in the event set.
Propriété publique CreateStatistics Gets or sets a Boolean property value that specifies whether the event that occurs when a statistic counter is created is included in the event set.
Propriété publique CreateXmlIndex Gets or sets a Boolean property value that specifies whether the event that occurs when an XML index is created is included in the event set.
Propriété publique DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event that occurs when a Full-Text Index is dropped is included in the event set.
Propriété publique DropIndex Gets or sets a Boolean property value that specifies whether the event that occurs when an index is dropped is included in the event set.
Propriété publique DropStatistics Gets or sets a Boolean property value that specifies whether the event that occurs when a statistic counter is dropped is included in the event set.
Propriété publique DropTable Gets or sets a Boolean property value that specifies whether the event that occurs when a table is dropped is included in the event set.
Propriété publique NumberOfElements Gets or sets a Boolean property value that specifies whether the event that occurs when a number of elements changes is included in the event set. (remplace EventSetBase.NumberOfElements.)
Propriété protégée Storage Gets or sets the bit array for event set storage. (hérité de EventSetBase.)
Propriété publique UpdateStatistics Gets or sets a Boolean property value that specifies whether the event that occurs when statistics are updated is included in the event set.

Haut de la page

Méthodes

  Nom Description
Méthode publique Add(TableEvent) Adds a TableEvent object to the TableEventSet object.
Méthode publiqueMembre statique Add(TableEventSet, TableEvent) Adds an event to the event set.
Méthode publique Copy Returns a copy of the event set. (remplace EventSetBase.Copy().)
Méthode publique Equals (hérité de Object.)
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetType (hérité de Object.)
Méthode publique Remove Removes an event from the event set.
Méthode publiqueMembre statique Subtract Removes an event from the event set.
Méthode publique ToString Returns a string that represents the TableEventSet object. (remplace Object.ToString().)

Haut de la page

Opérateurs

  Nom Description
Opérateur publicMembre statique Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Opérateur publicMembre statique Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

Haut de la page

Notes

SQL Server provides events subscription for all SMO objects that have server event support. The Table object has event support for the events that are represented by TableEventSet properties.

Thread Safety

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Exemples

Gestion des événements SMO

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Smo