TableEventSet-Klasse
The TableEventSet object represents a set of table events.
Vererbungshierarchie
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
Der TableEventSet-Typ macht folgende Elemente verfügbar.
Konstruktoren
Name | Beschreibung | |
---|---|---|
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. |
Zum Anfang
Eigenschaften
Name | Beschreibung | |
---|---|---|
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. (Überschreibt EventSetBase. . :: . .NumberOfElements.) | |
Storage | Gets or sets the bit array for event set storage. (Geerbt von 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. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
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. (Überschreibt EventSetBase. . :: . .Copy() () () ().) | |
Equals | (Geerbt von Object.) | |
Finalize | (Geerbt von Object.) | |
FitsMask | Specifies whether the EventSetBase object fits the specified mask. (Geerbt von EventSetBase.) | |
GetHashCode | (Geerbt von Object.) | |
GetType | (Geerbt von Object.) | |
HasCommonBits | Specifies whether the EventSetBase object has common bits with another specified EventSetBase object. (Geerbt von EventSetBase.) | |
MemberwiseClone | (Geerbt von Object.) | |
Remove | Removes an event from the event set. | |
SetValue | Sets the bit value at the specified index position. (Geerbt von EventSetBase.) | |
Subtract | Removes an event from the event set. | |
ToString | Returns a string that represents the TableEventSet object. (Überschreibt Object. . :: . .ToString() () () ().) |
Zum Anfang
Operatoren
Name | Beschreibung | |
---|---|---|
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. |
Zum Anfang
Hinweise
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
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.