Share via

  • Article

ViewEventSet Class

The ViewEventSet object represents a set of view events.

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class ViewEventSet _
    Inherits EventSetBase
'Usage
Dim instance As ViewEventSet

public sealed class ViewEventSet : EventSetBase

public ref class ViewEventSet sealed : public EventSetBase

[<SealedAttribute>]
type ViewEventSet =  
    class
        inherit EventSetBase
    end

public final class ViewEventSet extends EventSetBase

The ViewEventSet type exposes the following members.

Constructors

  Name Description
Public method ViewEventSet() Initializes a new instance of the ViewEventSet class.
Public method ViewEventSet(ViewEvent) Initializes a new instance of the ViewEventSet class with a specified event.
Public method ViewEventSet(array<ViewEvent[]) Initializes a new instance of the ViewEventSet class with a specified set of events.
Public method ViewEventSet(ViewEventSet) Initializes a new instance of the ViewEventSet 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 is included in the event set.
Public property AlterIndex Gets or sets a Boolean value that specifies whether the AlterIndex event is included in the event set.
Public property AlterView Gets or sets a Boolean property value that specifies whether the event that occurs when a view is altered is included in the event set.
Public property CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event 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 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 statistics 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 and included in the event set.
Public property DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event 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 DropView Gets or sets a Boolean property value that specifies whether the event that occurs when a view 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 the 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(ViewEvent) Adds a ViewEvent object to the ViewEventSet object.
Public methodStatic member Add(ViewEventSet, ViewEvent) 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.)
Protected method Finalize (Inherited from Object.)
Protected method FitsMask Specifies whether the EventSetBase object fits the specified mask. (Inherited from EventSetBase.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method HasCommonBits Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Inherited from EventSetBase.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Remove Removes an event from the event set.
Protected method SetValue Sets the bit value at the specified index position. (Inherited from EventSetBase.)
Public methodStatic member Subtract Removes a view event from the event set.
Public method ToString Returns a String that represents the ViewEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a view event set by performing an addition operation on a ViewEvent object and a ViewEventSet object.
Public operatorStatic member Subtraction Creates a view event set by performing a subtraction operation on a ViewEvent object and a ViewEventSet object.

Top

Remarks

SQL Server provides events subscription for all SMO objects that have server event support. The View object has event support for the events that are represented by ViewEventSet 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.

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.