DatabaseDdlTriggerEventSet Members

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

The following tables list the members exposed by the DatabaseDdlTriggerEventSet type.

Public Constructors

	名稱	Description
	DatabaseDdlTriggerEventSet	Overloaded. Initializes a new instance of the DatabaseDdlTriggerEventSet class.

頂端

Public Properties

(see also Protected Properties )

	名稱	Description
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	DdlApplicationRoleEvents	Gets or sets a Boolean property value that specifies whether DDL application role events are included in the event set.
	DdlAssemblyEvents	Gets or sets a Boolean property value that specifies whether DDL assembly events are included in the event set.
	DdlAuthorizationDatabaseEvents	Gets or sets a Boolean property value that specifies whether DDL authorization database events are included in the event set.
	DdlContractEvents	Gets or sets a Boolean property value that specifies whether DDL contract events are included in the event set.
	DdlDatabaseLevelEvents	Gets or sets a Boolean property value that specifies whether DDL database level events are included in the event set.
	DdlDatabaseSecurityEvents	Gets or sets a Boolean property value that specifies whether DDL database security events are included in the event set.
	DdlEventNotificationEvents	Gets or sets a Boolean property value that specifies whether DDL event notification events are included in the event set.
	DdlFunctionEvents	Gets or sets a Boolean property value that specifies whether DDL user-defined function events are included in the event set.
	DdlGdrDatabaseEvents	Gets or sets a Boolean property value that specifies whether DDL grant, deny, or revoke database events are included in the event set.
	DdlIndexEvents	Gets or sets a Boolean property value that specifies whether DDL index events are included in the event set.
	DdlMessageTypeEvents	Gets or sets a Boolean property value that specifies whether DDL message type events are included in the event set.
	DdlPartitionEvents	Gets or sets a Boolean property value that specifies whether DDL partition events are included in the event set.
	DdlPartitionFunctionEvents	Gets or sets a Boolean property value that specifies whether DDL partition function events are included in the event set.
	DdlPartitionSchemeEvents	Gets or sets a Boolean property value that specifies whether DDL partition scheme events are included in the event set.
	DdlProcedureEvents	Gets or sets a Boolean property value that specifies whether DDL stored procedure events are included in the event set.
	DdlQueueEvents	Gets or sets a Boolean property value that specifies whether DDL Service Broker queue events are included in the event set.
	DdlRemoteServiceBindingEvents	Gets or sets a Boolean property value that specifies whether DDL remote service binding events are included in the event set.
	DdlRoleEvents	Gets or sets a Boolean property value that specifies whether DDL database role events are included in the event set.
	DdlRouteEvents	Gets or sets a Boolean property value that specifies whether DDL Service Broker route events are included in the event set.
	DdlSchemaEvents	Gets or sets a Boolean property value that specifies whether DDL schema events are included in the event set.
	DdlServiceEvents	Gets or sets a Boolean property value that specifies whether DDL Service Broker service events are included in the event set.
	DdlSsbEvents	Gets or sets a Boolean property value that specifies whether DDL Service Broker events are included in the event set.
	DdlStatisticsEvents	Gets or sets a Boolean property value that specifies whether DDL statistics counter events are included in the event set.
	DdlSynonymEvents	Gets or sets a Boolean property value that specifies whether DDL synonym events are included in the event set.
	DdlTableEvents	Gets or sets a Boolean property value that specifies whether DDL table events are included in the event set.
	DdlTableViewEvents	Gets or sets a Boolean property value that specifies whether DDL table view events are included in the event set.
	DdlTriggerEvents	Gets or sets a Boolean property value that specifies whether DDL trigger events are included in the event set.
	DdlTypeEvents	Gets or sets a Boolean property value that specifies whether DDL type events are included in the event set.
	DdlUserEvents	Gets or sets a Boolean property value that specifies whether DDL database user events are included in the event set.
	DdlViewEvents	Gets or sets a Boolean property value that specifies whether DDL view events are included in the event set.
	DdlXmlSchemaCollectionEvents	Gets or sets a Boolean property value that specifies whether DDL XML schema collection events are 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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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	Overridden. Gets the number of events that are 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.
	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.

頂端

Protected Properties

	名稱	Description
	Storage	Gets or sets the bit array for event set storage. (inherited from EventSetBase)

頂端

Public Methods

(see also Protected Methods )

	名稱	Description
	Add	Overloaded. Returns a set of database DDL trigger events after adding a new event to the event set.
	Copy	Overridden. Returns a copy of the event set.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	op_Addition	Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
	op_Subtraction	Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
	ReferenceEquals	(inherited from Object )
	Remove	Removes an event from the event set.
	Subtract	Returns a set of database DDL trigger events after removing an event from the event specified set.
	ToString	Overridden. Returns a string that represents the DatabaseDdlTriggerEventSet object.

頂端

Protected Methods

	名稱	Description
	Finalize	(inherited from Object )
	FitsMask	(inherited from EventSetBase )
	HasCommonBits	(inherited from EventSetBase )
	MemberwiseClone	(inherited from Object )
	SetValue	(inherited from EventSetBase )

頂端

請參閱

參考

DatabaseDdlTriggerEventSet Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Handling SMO Events