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