• 아티클

ServerDdlTriggerEventType 열거형

Specifies the DDL events that can fire a DDL trigger.

네임스페이스:  Microsoft.SqlServer.Management.SqlParser.Metadata
어셈블리:  Microsoft.SqlServer.Management.SqlParser(Microsoft.SqlServer.Management.SqlParser.dll)

구문

‘선언
Public Enumeration ServerDdlTriggerEventType
‘사용 방법
Dim instance As ServerDdlTriggerEventType

public enum ServerDdlTriggerEventType

public enum class ServerDdlTriggerEventType

type ServerDdlTriggerEventType

public enum ServerDdlTriggerEventType

멤버

멤버 이름 설명
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.