Compartilhar via

Classe TableEventSet

  • Artigo

The TableEventSet object represents a set of table events.

Hierarquia de herança

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public NotInheritable Class TableEventSet _
    Inherits EventSetBase
'Uso
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

O tipo TableEventSet expõe os membros a seguir.

Construtores

  Nome Descrição
Método público TableEventSet() Initializes a new instance of the TableEventSet class.
Método público TableEventSet(TableEvent) Initializes a new instance of the TableEventSet class with a specified event.
Método público TableEventSet(array<TableEvent[]) Initializes a new instance of the TableEventSet class with a specified set of events.
Método público TableEventSet(TableEventSet) Initializes a new instance of the TableEventSet class with a specified set of events.

Início

Propriedades

  Nome Descrição
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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. (Substitui EventSetBase.NumberOfElements.)
Propriedade protegida Storage Gets or sets the bit array for event set storage. (Herdado de EventSetBase.)
Propriedade pública 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ício

Métodos

  Nome Descrição
Método público Add(TableEvent) Adds a TableEvent object to the TableEventSet object.
Método públicoMembro estático Add(TableEventSet, TableEvent) Adds an event to the event set.
Método público Copy Returns a copy of the event set. (Substitui EventSetBase.Copy().)
Método público Equals (Herdado de Object.)
Método público GetHashCode (Herdado de Object.)
Método público GetType (Herdado de Object.)
Método público Remove Removes an event from the event set.
Método públicoMembro estático Subtract Removes an event from the event set.
Método público ToString Returns a string that represents the TableEventSet object. (Substitui Object.ToString().)

Início

Operadores

  Nome Descrição
Operador públicoMembro estático Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Operador públicoMembro estático Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

Início

Comentários

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

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Manipulando eventos SMO

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo