TableEventSet 類別

The TableEventSet object represents a set of table events.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .EventSetBase
    Microsoft.SqlServer.Management.Smo..::..TableEventSet

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public NotInheritable Class TableEventSet _
    Inherits EventSetBase
'用途
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

TableEventSet 型別公開下列成員。

建構函式

	名稱	說明
	TableEventSet() () () ()	Initializes a new instance of the TableEventSet class.
	TableEventSet(TableEvent)	Initializes a new instance of the TableEventSet class with a specified event.
	TableEventSet(array<TableEvent> [] () [] [])	Initializes a new instance of the TableEventSet class with a specified set of events.
	TableEventSet(TableEventSet)	Initializes a new instance of the TableEventSet class with a specified set of events.

上層

屬性

	名稱	說明
	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.
	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.
	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.
	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.
	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 that occurs when a Spatial Index is created is included in the event set.
	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.
	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.
	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.
	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.
	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.
	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. (覆寫 EventSetBase. . :: . .NumberOfElements。)
	Storage	Gets or sets the bit array for event set storage. (繼承自 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.

上層

方法

	名稱	說明
	Add(TableEvent)	Adds a TableEvent object to the TableEventSet object.
	Add(TableEventSet, TableEvent)	Adds an event to the event set.
	Copy	Returns a copy of the event set. (覆寫 EventSetBase. . :: . .Copy() () () ()。)
	Equals	(繼承自 Object。)
	Finalize	(繼承自 Object。)
	FitsMask	Specifies whether the EventSetBase object fits the specified mask. (繼承自 EventSetBase。)
	GetHashCode	(繼承自 Object。)
	GetType	(繼承自 Object。)
	HasCommonBits	Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (繼承自 EventSetBase。)
	MemberwiseClone	(繼承自 Object。)
	Remove	Removes an event from the event set.
	SetValue	Sets the bit value at the specified index position. (繼承自 EventSetBase。)
	Subtract	Removes an event from the event set.
	ToString	Returns a string that represents the TableEventSet object. (覆寫 Object. . :: . .ToString() () () ()。)

上層

運算子

	名稱	說明
	Addition	Creates a table event set by performing an addition operation on a TableEvent object and a TableEventSet object.
	Subtraction	Creates a table event set by performing a subtraction operation on a TableEvent object and a TableEventSet object.

上層

備註

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

此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。不保證所有執行個體成員都是安全執行緒。

範例

處理 SMO 事件

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間