TableEvent Class

The TableEvent object represents the SQL Server table events that can be included in a table event set.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.TableEvent

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

Syntax

'Declaration
Public NotInheritable Class TableEvent
'Usage
Dim instance As TableEvent
public sealed class TableEvent
public ref class TableEvent sealed
[<SealedAttribute>]
type TableEvent =  class end
public final class TableEvent

The TableEvent type exposes the following members.

Properties

  Name Description
Public propertyStatic member AlterFulltextIndex Gets the Alter Full Text Index event.
Public propertyStatic member AlterIndex Gets a table event that can be included in the event set.
Public propertyStatic member AlterTable Gets a table event that can be included in the event set.
Public propertyStatic member CreateFulltextIndex Gets the Create Full Text Index event.
Public propertyStatic member CreateIndex Gets a table event that can be included in the event set.
Public propertyStatic member CreateSpatialIndex Gets the Create Spatial Index event.
Public propertyStatic member CreateStatistics Gets a table event that can be included in the event set.
Public propertyStatic member CreateXmlIndex Gets a table event that can be included in the event set.
Public propertyStatic member DropFulltextIndex Gets the Drop Full Text Index event.
Public propertyStatic member DropIndex Gets a table event that can be included in the event set.
Public propertyStatic member DropStatistics Gets a table event that can be included in the event set.
Public propertyStatic member DropTable Gets a table event that can be included in the event set.
Public propertyStatic member UpdateStatistics Gets a table event that can be included in the event set.

Top

Methods

  Name Description
Public methodStatic member Add Adds two events resulting in an Event Set.
Public methodStatic member BitwiseOr Combines two Table Events using a Bitwise OR to create a new Table Event Set.
Public method Equals Determines whether the referenced table event object is equal to a specified object. (Overrides Object.Equals(Object).)
Public method GetHashCode Gets the Hash Code for an event. (Overrides Object.GetHashCode().)
Public method GetType (Inherited from Object.)
Public method ToString Returns the referenced object in string format. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a table event set by performing an addition operation on two TableEvent objects.
Public operatorStatic member BitwiseOr Creates a table event set by performing a bitwise OR operation on two TableEvent objects.
Public operatorStatic member Equality Creates a table event set by performing an equality operation on two TableEvent objects.
Public operatorStatic member Implicit(TableEvent to TableEventSet) Casts a single Table Event as a Table Event Set.
Public operatorStatic member Inequality Creates a table event set by performing an inequality operation on two TableEvent objects.

Top

Remarks

The TableEvent object contains a property for each event to which the table can respond. The actual set of events is specified using the TableEventSet object.

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.

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

Other Resources

Handling SMO Events