Compartir a través de


Clase TableEventSet

The TableEventSet object represents a set of table events.

Jerarquía de herencia

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
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

El tipo TableEventSet expone los siguientes miembros.

Constructores

  Nombre Descripción
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.

Arriba

Propiedades

  Nombre Descripción
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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.
Propiedad 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. (Invalida EventSetBase.NumberOfElements.)
Propiedad protegida Storage Gets or sets the bit array for event set storage. (Se hereda de EventSetBase.)
Propiedad 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.

Arriba

Métodos

  Nombre Descripción
Método público Add(TableEvent) Adds a TableEvent object to the TableEventSet object.
Método públicoMiembro estático Add(TableEventSet, TableEvent) Adds an event to the event set.
Método público Copy Returns a copy of the event set. (Invalida EventSetBase.Copy().)
Método público Equals (Se hereda de Object.)
Método público GetHashCode (Se hereda de Object.)
Método público GetType (Se hereda de Object.)
Método público Remove Removes an event from the event set.
Método públicoMiembro estático Subtract Removes an event from the event set.
Método público ToString Returns a string that represents the TableEventSet object. (Invalida Object.ToString().)

Arriba

Operadores

  Nombre Descripción
Operador públicoMiembro estático Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Operador públicoMiembro estático Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

Arriba

Comentarios

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

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Ejemplos

Controlar eventos SMO

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Smo