ServerDdlTriggerEventType Enumeration
Specifies the DDL events that can fire a DDL trigger.
Namespace: Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
Syntax
'Declaration
Public Enumeration ServerDdlTriggerEventType
'Usage
Dim instance As ServerDdlTriggerEventType
public enum ServerDdlTriggerEventType
public enum class ServerDdlTriggerEventType
type ServerDdlTriggerEventType
public enum ServerDdlTriggerEventType
Members
| Member name | Description | |
|---|---|---|
| AlterApplicationRole | The ALTER_APPLICATION_ROLE event. | |
| AlterAssembly | The ALTER_ASSEMBLY event. | |
| AlterAuthorizationDatabase | The ALTER_AUTHORIZATION_DATABASE event. | |
| AlterCertificate | The ALTER_CERTIFICATE event. | |
| AlterFulltextCatalog | The ALTER_FULLTEXT_CATALOG event. | |
| AlterFulltextIndex | The ALTER_FULLTEXT_INDEX event. | |
| AlterFunction | The ALTER_FUNCTION event. | |
| AlterIndex | The ALTER_INDEX event. | |
| AlterMessageType | The ALTER_MESSAGE_TYPE event. | |
| AlterPartitionFunction | The ALTER_PARTITION_FUNCTION event. | |
| AlterPartitionScheme | The ALTER_PARTITION_SCHEME event. | |
| AlterPlanGuide | The ALTER_PLAN_GUIDE event. | |
| AlterProcedure | The ALTER_PROCEDURE event. | |
| AlterQueue | The ALTER_QUEUE event. | |
| AlterRemoteServiceBinding | The ALTER_REMOTE_SERVICE_BINDING event. | |
| AlterRole | The ALTER_ROLE event. | |
| AlterRoute | The ALTER_ROUTE event. | |
| AlterSchema | The ALTER_SCHEMA event. | |
| AlterService | The ALTER_SERVICE event. | |
| AlterTable | The ALTER_TABLE event. | |
| AlterTrigger | The ALTER_TRIGGER event. | |
| AlterUser | The ALTER_USER event. | |
| AlterView | The ALTER_VIEW event. | |
| AlterXmlSchemaCollection | The ALTER_XML_SCHEMA_COLLECTION event. | |
| BindDefault | The BIND_DEFAULT event. | |
| BindRule | The BIND_RULE event. | |
| CreateApplicationRole | The CREATE_APPLICATION_ROLE event. | |
| CreateAssembly | The CREATE_ASSEMBLY event. | |
| CreateCertificate | The CREATE_CERTIFICATE event. | |
| CreateContract | The CREATE_CONTRACT event. | |
| CreateDefault | The CREATE_DEFAULT event. | |
| CreateEventNotification | The CREATE_EVENT_NOTIFICATION event. | |
| CreateExtendedProperty | The CREATE_EXTENDED_PROPERTY event. | |
| CreateFulltextCatalog | The CREATE_FULLTEXT_CATALOG event. | |
| CreateFulltextIndex | The CREATE_FULLTEXT_INDEX event. | |
| CreateFunction | The CREATE_FUNCTION event. | |
| CreateIndex | The CREATE_INDEX event. | |
| CreateMessageType | The CREATE_MESSAGE_TYPE event. | |
| CreatePartitionFunction | The CREATE_PARTITION_FUNCTION event. | |
| CreatePartitionScheme | The CREATE_PARTITION_SCHEME event. | |
| CreatePlanGuide | The CREATE_PLAN_GUIDE event. | |
| CreateProcedure | The CREATE_PROCEDURE event. | |
| CreateQueue | The CREATE_QUEUE event. | |
| CreateRemoteServiceBinding | The CREATE_REMOTE_SERVICE_BINDING event. | |
| CreateRole | The CREATE_ROLE event. | |
| CreateRoute | The CREATE_ROUTE event. | |
| CreateRule | The CREATE_RULE event. | |
| CreateSchema | The CREATE_SCHEMA event. | |
| CreateService | The CREATE_SERVICE event. | |
| CreateSpatialIndex | The CREATE SPATIAL INDEX event. | |
| CreateStatistics | The CREATE_STATISTICS event. | |
| CreateSynonym | The CREATE_SYNONYM event. | |
| CreateTable | The CREATE_TABLE event. | |
| CreateTrigger | The CREATE_TRIGGER event. | |
| CreateType | The CREATE_TYPE event. | |
| CreateUser | The CREATE_USER event. | |
| CreateView | The CREATE_VIEW event. | |
| CreateXmlIndex | The CREATE_XML_INDEX event. | |
| CreateXmlSchemaCollection | The CREATE_XML_SCHEMA_COLLECTION event. | |
| DenyDatabase | The DENY_DATABASE event. | |
| DropApplicationRole | The DROP_APPLICATION_ROLE event. | |
| DropAssembly | The DROP_ASSEMBLY event. | |
| DropCertificate | The DROP_CERTIFICATE event. | |
| DropContract | The DROP_CONTRACT event. | |
| DropDefault | The DROP_DEFAULT event. | |
| DropEventNotification | The DROP_EVENT_NOTIFICATION event. | |
| DropExtendedProperty | The DROP_EXTENDED_PROPERTY event. | |
| DropFulltextCatalog | The DROP_FULLTEXT_CATALOG event. | |
| DropFulltextIndex | The DROP_FULLTEXT_INDEX event. | |
| DropFunction | The DROP_FUNCTION event. | |
| DropIndex | The DROP_INDEX event. | |
| DropMessageType | The DROP_MESSAGE_TYPE event. | |
| DropPartitionFunction | The DROP_PARTITION_FUNCTION event. | |
| DropPartitionScheme | The DROP_PARTITION_SCHEME event. | |
| DropPlanGuide | The DROP_PLAN_GUIDE event. | |
| DropProcedure | The DROP_PROCEDURE event. | |
| DropQueue | The DROP_QUEUE event. | |
| DropRemoteServiceBinding | The DROP_REMOTE_SERVICE_BINDING event. | |
| DropRole | The DROP_ROLE event. | |
| DropRoute | The DROP_ROUTE event. | |
| DropRule | The DROP_RULE event. | |
| DropSchema | The DROP_SCHEMA event. | |
| DropService | The DROP_SERVICE event. | |
| DropStatistics | The DROP_STATISTICS event. | |
| DropSynonym | The DROP_SYNONYM event. | |
| DropTable | The DROP_TABLE event. | |
| DropTrigger | The DROP_TRIGGER event. | |
| DropType | The DROP_TYPE event. | |
| DropUser | The DROP_USER event. | |
| DropView | The DROP_VIEW event. | |
| DropXmlSchemaCollection | The DROP_XML_SCHEMA_COLLECTION event. | |
| GrantDatabase | The GRANT_DATABASE event. | |
| RevokeDatabase | The REVOKE_DATABASE event. | |
| UpdateStatistics | The UPDATE_STATISTICS event. | |
| AddRoleMember | The ADD_ROLE_MEMBER event. | |
| AddServerRoleMember | The ADD_SERVER_ROLE_MEMBER event. | |
| AlterAuthorizationServer | The ALTER_AUTHORIZATION_SERVER event. | |
| AlterDatabase | The ALTER_DATABASE event. | |
| AlterEndpoint | The ALTER_ENDPOINT event. | |
| AlterInstance | The ALTER_INSTANCE event. | |
| AlterLinkedServer | The ALTER_LINKED_SERVER event. | |
| AlterLogin | The ALTER_LOGIN event. | |
| AlterMessage | The ALTER_MESSAGE event. | |
| AlterRemoteServer | The ALTER_REMOTE_SERVER event. | |
| CreateDatabase | The CREATE_DATABASE event. | |
| CreateEndpoint | The CREATE_ENDPOINT event. | |
| CreateExtendedProcedure | The CREATE_EXTENDED_PROCEDURE event. | |
| CreateLinkedServer | The CREATE_LINKED_SERVER event. | |
| CreateLinkedServerLogin | The CREATE_LINKED_SERVER_LOGIN event. | |
| CreateLogin | The CREATE_LOGIN event. | |
| CreateMessage | The CREATE_MESSAGE event. | |
| CreateRemoteServer | The CREATE_REMOTE_SERVER event. | |
| DenyServer | The DENY_SERVER event. | |
| DropDatabase | The DROP_DATABASE event. | |
| DropEndpoint | The DROP_ENDPOINT event. | |
| DropExtendedProcedure | The DROP_EXTENDED_PROCEDURE event. | |
| DropLinkedServer | The DROP_LINKED_SERVER event. | |
| DropLinkedServerLogin | The DROP_LINKED_SERVER_LOGIN event. | |
| DropLogin | The DROP_LOGIN event. | |
| DropMessage | The DROP_MESSAGE event. | |
| DropRemoteServer | The DROP_REMOTE_SERVER event. | |
| DropRoleMember | The DROP_ROLE_MEMBER event. | |
| DropServerRoleMember | The DROP_SERVER_ROLE_MEMBER event. | |
| GrantServer | The GRANT_SERVER event. | |
| Logon | The LOGON event. | |
| RevokeServer | The REVOKE_SERVER event. |