DatabaseDdlTriggerEventSet 類別

The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events.

繼承階層

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

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

語法

'宣告
Public NotInheritable Class DatabaseDdlTriggerEventSet _
    Inherits EventSetBase
'用途
Dim instance As DatabaseDdlTriggerEventSet

public sealed class DatabaseDdlTriggerEventSet : EventSetBase

public ref class DatabaseDdlTriggerEventSet sealed : public EventSetBase

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

public final class DatabaseDdlTriggerEventSet extends EventSetBase

DatabaseDdlTriggerEventSet 型別公開下列成員。

建構函式

	名稱	說明
	DatabaseDdlTriggerEventSet() () () ()	Initializes a new instance of the DatabaseDdlTriggerEventSet class.
	DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent)	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
	DatabaseDdlTriggerEventSet(array<DatabaseDdlTriggerEvent> [] () [] [])	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
	DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEventSet)	Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

上層

屬性

	名稱	說明
	AddRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AddSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AddSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered.
	AlterAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered.
	AlterAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterAuthorizationDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization database is altered.
	AlterBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
	AlterDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is altered.
	AlterFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered.
	AlterIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered.
	AlterMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered.
	AlterPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered.
	AlterPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered.
	AlterPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered.
	AlterQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered.
	AlterRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered.
	AlterRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered.
	AlterRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered.
	AlterSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered.
	AlterService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered.
	AlterSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	AlterTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered.
	AlterTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered.
	AlterUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered.
	AlterView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered.
	AlterXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered.
	BindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	BindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created.
	CreateAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created.
	CreateAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created.
	CreateDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created.
	CreateDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created.
	CreateExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event 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.
	CreateFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is created.
	CreateFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created.
	CreateIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created.
	CreateMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created.
	CreatePartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created.
	CreatePartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created.
	CreatePlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is created.
	CreateQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created.
	CreateRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created.
	CreateRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created.
	CreateRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created.
	CreateRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created.
	CreateService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created.
	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 is included in the event set. The event occurs when a statistics counter is created.
	CreateSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	CreateSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created.
	CreateTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created.
	CreateTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created.
	CreateType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created.
	CreateUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created.
	CreateView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created.
	CreateXmlIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created.
	CreateXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created.
	DdlApplicationRoleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAssemblyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAsymmetricKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlAuthorizationDatabaseEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlBrokerPriorityEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlCertificateEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlContractEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlCryptoSignatureEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseAuditSpecificationEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseEncryptionKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseLevelEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDatabaseSecurityEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlDefaultEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlEventNotificationEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlExtendedPropertyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFulltextCatalogEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFulltextStoplistEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlFunctionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlGdrDatabaseEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlIndexEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlMasterKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlMessageTypeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionFunctionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPartitionSchemeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlPlanGuideEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlProcedureEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlQueueEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRemoteServiceBindingEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRoleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRouteEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlRuleEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSchemaEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlServiceEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSsbEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlStatisticsEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSymmetricKeyEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlSynonymEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTableEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTableViewEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTriggerEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlTypeEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlUserEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlViewEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DdlXmlSchemaCollectionEventsEvents	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DenyDatabase	Gets or sets a Boolean property value that specifies whether events are included in the event set.
	Dirty	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when data stored in the cache needs refreshing is encountered.
	DropApplicationRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped.
	DropAssembly	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped.
	DropAsymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropBrokerPriority	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropCertificate	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropContract	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped.
	DropDatabaseAuditSpecification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
	DropDatabaseEncryptionKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropEventNotification	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped.
	DropExtendedProperty	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextCatalog	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropFulltextStoplist	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is dropped.
	DropFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped.
	DropIndex	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped.
	DropMasterKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropMessageType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped.
	DropPartitionFunction	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped.
	DropPartitionScheme	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped.
	DropPlanGuide	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropProcedure	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped.
	DropQueue	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Service Broker queue is dropped.
	DropRemoteServiceBinding	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped.
	DropRole	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped.
	DropRoleMember	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropRoute	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped.
	DropRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSchema	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped.
	DropService	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped.
	DropSignature	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSignatureSchemaObject	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped.
	DropSymmetricKey	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	DropSynonym	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped.
	DropTable	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped.
	DropTrigger	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped.
	DropType	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped.
	DropUser	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped.
	DropView	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped.
	DropXmlSchemaCollection	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped.
	GrantDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
	NumberOfElements	Gets the number of events that are included in the event set. (覆寫 EventSetBase. . :: . .NumberOfElements。)
	Rename	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	RevokeDatabase	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is revoked from the database.
	Storage	Gets or sets the bit array for event set storage. (繼承自 EventSetBase。)
	UnbindDefault	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UnbindRule	Gets or sets a Boolean property value that specifies whether the event is included in the event set.
	UpdateStatistics	Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when statistics are updated.

上層

方法

	名稱	說明
	Add(DatabaseDdlTriggerEvent)	Returns a set of database DDL trigger events after adding a new event to the event referenced set.
	Add(DatabaseDdlTriggerEventSet, DatabaseDdlTriggerEvent)	Returns a set of database DDL trigger events after adding a new event to the event specified 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	Returns a set of database DDL trigger events after removing an event from the event specified set.
	ToString	Returns a string that represents the DatabaseDdlTriggerEventSet object. (覆寫 Object. . :: . .ToString() () () ()。)

上層

運算子

	名稱	說明
	Addition	Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
	Subtraction	Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.

上層

備註

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The DatabaseDdlTriggerEventSet object contains a property for each event to which the database DDL trigger responds.

Thread Safety

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

範例

處理 SMO 事件

執行緒安全性

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

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間