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
	ViewEventSet()	Initializes a new instance of the ViewEventSet class.
	ViewEventSet(ViewEvent)	Initializes a new instance of the ViewEventSet class with a specified event.
	ViewEventSet(array<ViewEvent[])	Initializes a new instance of the ViewEventSet class with a specified set of events.
	ViewEventSet(ViewEventSet)	Initializes a new instance of the ViewEventSet class with a specified set of events.

Top

Properties

	Name	Description
	AlterFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterIndex	Gets or sets a Boolean value that specifies whether the AlterIndex event is included in the event set.
	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.
	CreateFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set
	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.
	CreateSpatialIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set
	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.
	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.
	DropFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set
	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.
	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.
	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.
	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.)
	Storage	Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
	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
	Add(ViewEvent)	Adds a ViewEvent object to the ViewEventSet object.
	Add(ViewEventSet, ViewEvent)	Adds an event to the event set.
	Copy	Returns a copy of the event set. (Overrides EventSetBase.Copy().)
	Equals	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	Remove	Removes an event from the event set.
	Subtract	Removes a view event from the event set.
	ToString	Returns a String that represents the ViewEventSet object. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a view event set by performing an addition operation on a ViewEvent object and a ViewEventSet object.
	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.

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