Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

TableEventSet Class

The TableEventSet object represents a set of table events.

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public sealed class TableEventSet : EventSetBase

The TableEventSet type exposes the following members.

  NameDescription
Public methodTableEventSet()Initializes a new instance of the TableEventSet class.
Public methodTableEventSet(TableEvent)Initializes a new instance of the TableEventSet class with a specified event.
Public methodTableEventSet(TableEvent[])Initializes a new instance of the TableEventSet class with a specified set of events.
Public methodTableEventSet(TableEventSet)Initializes a new instance of the TableEventSet class with a specified set of events.
Top
  NameDescription
Public propertyAlterFulltextIndexGets 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.
Public propertyAlterIndexGets or sets a Boolean property value that specifies whether the event that occurs when an index is altered is included in the event set.
Public propertyAlterTableGets or sets a Boolean property value that specifies whether the event that occurs when a table is altered is included in the event set.
Public propertyCreateFulltextIndexGets 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.
Public propertyCreateIndexGets or sets a Boolean property value that specifies whether the event that occurs when an index is created is included in the event set.
Public propertyCreateSpatialIndexGets 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.
Public propertyCreateStatisticsGets 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.
Public propertyCreateXmlIndexGets 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.
Public propertyDropFulltextIndexGets 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.
Public propertyDropIndexGets or sets a Boolean property value that specifies whether the event that occurs when an index is dropped is included in the event set.
Public propertyDropStatisticsGets 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.
Public propertyDropTableGets or sets a Boolean property value that specifies whether the event that occurs when a table is dropped is included in the event set.
Public propertyNumberOfElementsGets 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.)
Protected propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public propertyUpdateStatisticsGets or sets a Boolean property value that specifies whether the event that occurs when statistics are updated is included in the event set.
Top
  NameDescription
Public methodAdd(TableEvent)Adds a TableEvent object to the TableEventSet object.
Public methodStatic memberAdd(TableEventSet, TableEvent)Adds an event to the event set.
Public methodCopyReturns a copy of the event set. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Public methodStatic memberSubtractRemoves an event from the event set.
Public methodToStringReturns a string that represents the TableEventSet object. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Public operatorStatic memberSubtractionCreates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.