TableEventSet Class

The TableEventSet object represents a set of table events.

Inheritance Hierarchy

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)

Syntax

'Declaration
Public NotInheritable Class TableEventSet _
    Inherits EventSetBase
'Usage
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

The TableEventSet type exposes the following members.

Constructors

  Name Description
Public method TableEventSet() Initializes a new instance of the TableEventSet class.
Public method TableEventSet(TableEvent) Initializes a new instance of the TableEventSet class with a specified event.
Public method TableEventSet(array<TableEvent[]) Initializes a new instance of the TableEventSet class with a specified set of events.
Public method TableEventSet(TableEventSet) Initializes a new instance of the TableEventSet class with a specified set of events.

Top

Properties

  Name Description
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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.
Public property 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. (Overrides EventSetBase.NumberOfElements.)
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public property 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

Methods

  Name Description
Public method Add(TableEvent) Adds a TableEvent object to the TableEventSet object.
Public methodStatic member Add(TableEventSet, TableEvent) Adds an event to the event set.
Public method Copy Returns a copy of the event set. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method Remove Removes an event from the event set.
Public methodStatic member Subtract Removes an event from the event set.
Public method ToString Returns a string that represents the TableEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
Public operatorStatic member Subtraction Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

Top

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.

Examples

Handling SMO Events

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace