Condividi tramite


Classe TableEventSet

The TableEventSet object represents a set of table events.

Gerarchia di ereditarietà

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

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

Sintassi

'Dichiarazione
Public NotInheritable Class TableEventSet _
    Inherits EventSetBase
'Utilizzo
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

Nel tipo TableEventSet sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico TableEventSet() Initializes a new instance of the TableEventSet class.
Metodo pubblico TableEventSet(TableEvent) Initializes a new instance of the TableEventSet class with a specified event.
Metodo pubblico TableEventSet(array<TableEvent[]) Initializes a new instance of the TableEventSet class with a specified set of events.
Metodo pubblico TableEventSet(TableEventSet) Initializes a new instance of the TableEventSet class with a specified set of events.

In alto

Proprietà

  Nome Descrizione
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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.
Proprietà pubblica 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. Esegue l'override di EventSetBase.NumberOfElements.
Proprietà protetta Storage Gets or sets the bit array for event set storage. Ereditato da EventSetBase.
Proprietà pubblica 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.

In alto

Metodi

  Nome Descrizione
Metodo pubblico Add(TableEvent) Adds a TableEvent object to the TableEventSet object.
Metodo pubblicoMembro statico Add(TableEventSet, TableEvent) Adds an event to the event set.
Metodo pubblico Copy Returns a copy of the event set. Esegue l'override di EventSetBase.Copy().
Metodo pubblico Equals Ereditato da Object.
Metodo pubblico GetHashCode Ereditato da Object.
Metodo pubblico GetType Ereditato da Object.
Metodo pubblico Remove Removes an event from the event set.
Metodo pubblicoMembro statico Subtract Removes an event from the event set.
Metodo pubblico ToString Returns a string that represents the TableEventSet object. Esegue l'override di Object.ToString().

In alto

Operatori

  Nome Descrizione
Operatore pubblicoMembro statico Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Operatore pubblicoMembro statico Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

In alto

Osservazioni

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

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Esempi

Gestione degli eventi SMO

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Management.Smo