TableEventSet Members

The TableEventSet object represents a set of table events.

The following tables list the members exposed by the TableEventSet type.

Public Constructors

  Name Description
TableEventSet Overloaded. Initializes a new instance of the TableEventSet class.

Top

Public Properties

(see also Protected Properties )

  Name Description
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.
ms220468.pubproperty(en-US,SQL.90).gif NumberOfElements Overridden. 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.
ms220468.pubproperty(en-US,SQL.90).gif 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.

Top

Protected Properties

  Name Description
ms220468.protproperty(en-US,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220468.pubmethod(en-US,SQL.90).gif Add Overloaded.  
ms220468.pubmethod(en-US,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms220468.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220468.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220468.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220468.pubmethod(en-US,SQL.90).gifms220468.static(en-US,SQL.90).gif op_Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
ms220468.pubmethod(en-US,SQL.90).gifms220468.static(en-US,SQL.90).gif op_Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.
ms220468.pubmethod(en-US,SQL.90).gifms220468.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220468.pubmethod(en-US,SQL.90).gif Remove Removes an event from the event set.
ms220468.pubmethod(en-US,SQL.90).gifms220468.static(en-US,SQL.90).gif Subtract  
ms220468.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a string that represents the TableEventSet object.

Top

Protected Methods

  Name Description
ms220468.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220468.protmethod(en-US,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms220468.protmethod(en-US,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms220468.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220468.protmethod(en-US,SQL.90).gif SetValue  (inherited from EventSetBase )

Top

See Also

Reference

TableEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events