TechNet
Export (0) Print
Expand All

TableEventSet Class

 

The TableEventSet object represents a set of table events.

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

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

public sealed class TableEventSet : EventSetBase

NameDescription
System_CAPS_pubmethodTableEventSet()

Initializes a new instance of the TableEventSet class.

System_CAPS_pubmethodTableEventSet(TableEvent)

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

System_CAPS_pubmethodTableEventSet(TableEvent[])

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

System_CAPS_pubmethodTableEventSet(TableEventSet)

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

NameDescription
System_CAPS_pubpropertyAlterFulltextIndex

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.

System_CAPS_pubpropertyAlterIndex

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.

System_CAPS_pubpropertyAlterTable

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.

System_CAPS_pubpropertyCreateFulltextIndex

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.

System_CAPS_pubpropertyCreateIndex

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.

System_CAPS_pubpropertyCreateSpatialIndex

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.

System_CAPS_pubpropertyCreateStatistics

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.

System_CAPS_pubpropertyCreateXmlIndex

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.

System_CAPS_pubpropertyDropFulltextIndex

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.

System_CAPS_pubpropertyDropIndex

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.

System_CAPS_pubpropertyDropStatistics

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.

System_CAPS_pubpropertyDropTable

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.

System_CAPS_pubpropertyNumberOfElements

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.(Overrides EventSetBase.NumberOfElements.)

System_CAPS_protpropertyStorage

Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

System_CAPS_pubpropertyUpdateStatistics

Gets or sets a Boolean property value that specifies whether the event that occurs when statistics are updated is included in the event set.

NameDescription
System_CAPS_pubmethodAdd(TableEvent)

Adds a TableEvent object to the TableEventSet object.

System_CAPS_pubmethodSystem_CAPS_staticAdd(TableEventSet, TableEvent)

Adds an event to the event set.

System_CAPS_pubmethodCopy()

Returns a copy of the event set.(Overrides EventSetBase.Copy().)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(TableEvent)

Removes an event from the event set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(TableEventSet, TableEvent)

Removes an event from the event set.

System_CAPS_pubmethodToString()

Returns a string that represents the TableEventSet object.(Overrides Object.ToString().)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(TableEventSet, TableEvent)

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

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(TableEventSet, TableEvent)

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

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.

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.

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

Return to top
Show:
© 2016 Microsoft