TableEventSet TableEventSet TableEventSet Class

Definition

The TableEventSet object represents a set of table events.

public ref class TableEventSet sealed : Microsoft::SqlServer::Management::Smo::EventSetBase
public sealed class TableEventSet : Microsoft.SqlServer.Management.Smo.EventSetBase
Public NotInheritable Class TableEventSet
Inherits EventSetBase
Inheritance
TableEventSetTableEventSetTableEventSet

Examples

Handling SMO Events

Remarks

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

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

Constructors

TableEventSet() TableEventSet() TableEventSet()

Initializes a new instance of the TableEventSet class.

TableEventSet(TableEvent) TableEventSet(TableEvent) TableEventSet(TableEvent)

Initializes a new instance of the TableEventSet class with a specified event.

TableEventSet(TableEventSet) TableEventSet(TableEventSet) TableEventSet(TableEventSet)

Initializes a new instance of the TableEventSet class with a specified set of events.

TableEventSet(TableEvent[]) TableEventSet(TableEvent[]) TableEventSet(TableEvent[])

Initializes a new instance of the TableEventSet class with a specified set of events.

Properties

AlterFulltextIndex AlterFulltextIndex 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.

AlterIndex AlterIndex 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.

AlterTable AlterTable 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.

CreateFulltextIndex CreateFulltextIndex 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.

CreateIndex CreateIndex 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.

CreateSpatialIndex CreateSpatialIndex 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.

CreateStatistics CreateStatistics 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.

CreateXmlIndex CreateXmlIndex 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.

DropFulltextIndex DropFulltextIndex 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.

DropIndex DropIndex 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.

DropStatistics DropStatistics 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.

DropTable DropTable 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.

NumberOfElements NumberOfElements 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.

Storage Storage Storage

Gets or sets the bit array for event set storage.

(Inherited from EventSetBase)
UpdateStatistics UpdateStatistics 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.

Methods

Add(TableEvent) Add(TableEvent) Add(TableEvent)

Adds a TableEvent object to the TableEventSet object.

Add(TableEventSet, TableEvent) Add(TableEventSet, TableEvent) Add(TableEventSet, TableEvent)

Adds an event to the event set.

Copy() Copy() Copy()

Returns a copy of the event set.

FitsMask(EventSetBase) FitsMask(EventSetBase) FitsMask(EventSetBase)

Specifies whether the EventSetBase object fits the specified mask.

(Inherited from EventSetBase)
HasCommonBits(EventSetBase) HasCommonBits(EventSetBase) HasCommonBits(EventSetBase)

Specifies whether the EventSetBase object has common bits with another specified EventSetBase object.

(Inherited from EventSetBase)
Remove(TableEvent) Remove(TableEvent) Remove(TableEvent)

Removes an event from the event set.

SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean) SetValue(EventSetBase, Boolean)

Sets the bit value at the specified index position.

(Inherited from EventSetBase)
Subtract(TableEventSet, TableEvent) Subtract(TableEventSet, TableEvent) Subtract(TableEventSet, TableEvent)

Removes an event from the event set.

ToString() ToString() ToString()

Returns a string that represents the TableEventSet object.

Operators

Addition(TableEventSet, TableEvent) Addition(TableEventSet, TableEvent) Addition(TableEventSet, TableEvent)

Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.

Subtraction(TableEventSet, TableEvent) Subtraction(TableEventSet, TableEvent) Subtraction(TableEventSet, TableEvent)

Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

Applies to