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.

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace