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. | |
AlterSearchPropertyList | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
AlterSequence | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
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. | |
CreateSearchPropertyList | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
CreateSequence | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
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. | |
DdlSearchPropertyListEventsEvents | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
DdlSequenceEventsEvents | 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. | |
DropSearchPropertyList | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
DropSequence | Gets or sets a Boolean property value that specifies whether the event is included in the event set. | |
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 继承。) | |
GetHashCode | (从 Object 继承。) | |
GetType | (从 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 | 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 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。