ServerDdlTriggerEvent Class
The ServerDdlTriggerEvent object represents the Microsoft SQL Server data definition language (DDL) trigger events that can be included in a server DDL trigger event set.
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)
| Name | Description | |
|---|---|---|
![]() ![]() | AddRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AddServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AddSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AddSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterAuthorizationDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterAuthorizationServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterCertificate | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterColumnEncryptionKey | Gets a ServerDdlTriggerEvent that alters column encryption key. |
![]() ![]() | AlterCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterInstance | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterResourceGovernorConfig | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterSecurityPolicy | Gets the ServerDdlTriggerEvent that alters security policy. |
![]() ![]() | AlterSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterServiceMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | AlterXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | BindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | BindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateColumnEncryptionKey | Gets the encryption key for the server. |
![]() ![]() | CreateColumnMasterKey | Gets the column master key. |
![]() ![]() | CreateContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateEndpoint | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreatePartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreatePartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreatePlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSecurityPolicy | Gets the security policy for the triggered event. |
![]() ![]() | CreateSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSpatialIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateXmlIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | CreateXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DenyDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DenyServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropApplicationRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropAssembly | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropAsymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropAvailabilityGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropBrokerPriority | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropCertificate | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropColumnEncryptionKey | Gets the ServerDdlTriggerEvent that drops the column encryption key. |
![]() ![]() | DropColumnMasterKey | Gets the server Ddl trigger event for the drop column master key. |
![]() ![]() | DropContract | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropCredential | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropCryptographicProvider | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropDatabaseAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropDatabaseEncryptionKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropEndpoint | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropEventNotification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropEventSession | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropExtendedProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropExtendedProperty | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropFulltextCatalog | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropFulltextIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropFulltextStoplist | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropIndex | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropLinkedServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropLinkedServerLogin | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropLogin | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropMasterKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropMessage | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropMessageType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropPartitionFunction | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropPartitionScheme | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropPlanGuide | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropProcedure | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropQueue | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRemoteServer | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRemoteServiceBinding | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropResourcePool | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRoute | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSchema | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSearchPropertyList | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSecurityPolicy | Gets a ServerDdlTriggerEvent that drops security policy. |
![]() ![]() | DropSequence | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropServerAudit | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropServerAuditSpecification | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropServerRole | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropServerRoleMember | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropService | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSignature | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSignatureSchemaObject | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSymmetricKey | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropSynonym | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropTable | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropTrigger | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropType | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropUser | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropView | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropWorkloadGroup | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | DropXmlSchemaCollection | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | GrantDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | GrantServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | Logon | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | Rename | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | RevokeDatabase | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | RevokeServer | Gets a server data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | UnbindDefault | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | UnbindRule | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
![]() ![]() | UpdateStatistics | Gets a database data definition language (DDL) trigger event that can be included in the event set. |
| Name | Description | |
|---|---|---|
![]() ![]() | Add(ServerDdlTriggerEvent^, ServerDdlTriggerEvent^) | Returns a Server DDL trigger event set after adding an SQL DLL trigger event to the event set. |
![]() ![]() | BitwiseOr(ServerDdlTriggerEvent^, ServerDdlTriggerEvent^) | Creates a new object event set by performing a BitwiseOr operation on two ServerDdlTriggerEvent objects. |
![]() | Equals(Object^) | (Inherited from Object.) |
![]() | GetHashCode() | (Inherited from Object.) |
![]() | GetType() | (Inherited from Object.) |
![]() | ToString() | Returns the object in String format.(Overrides Object::ToString().) |
| Name | Description | |
|---|---|---|
![]() ![]() | Addition(ServerDdlTriggerEvent^, ServerDdlTriggerEvent^) | Creates a server event set by performing an addition operation on two ServerDdlTriggerEvent objects. |
![]() ![]() | BitwiseOr(ServerDdlTriggerEvent^, ServerDdlTriggerEvent^) | Creates a server event set by performing a bitwise OR operation on two ServerDdlTriggerEvent objects. |
![]() ![]() | Implicit(ServerDdlTriggerEvent^ to ServerDdlTriggerEventSet^) | Creates a server event set by performing an implicit operation on a ServerDdlTriggerEvent object. |
DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The ServerDdlTriggerEvent object contains a property for each event to which the server DDL trigger can respond. The actual set of events is specified using the ServerDdlTriggerEventSet object.
Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



