SQL Server
United States (English)
Sign in
Home 2014 2012 2008 R2 2008 Previous Versions Library Forums
Export (0) Print
Expand All
TechNet Library
SQL Server
SQL Server 2014
Product Documentation
Developer Reference for SQL Server 2014
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
ServerDdlTriggerEvent Class
ServerDdlTriggerEvent Properties
AddRoleMember Property
AddServerRoleMember Property
AddSignature Property
AddSignatureSchemaObject Property
AlterApplicationRole Property
AlterAssembly Property
AlterAsymmetricKey Property
AlterAuthorizationDatabase Property
AlterAuthorizationServer Property
AlterAvailabilityGroup Property
AlterBrokerPriority Property
AlterCertificate Property
AlterCredential Property
AlterCryptographicProvider Property
AlterDatabase Property
AlterDatabaseAuditSpecification Property
AlterDatabaseEncryptionKey Property
AlterEndpoint Property
AlterEventSession Property
AlterExtendedProperty Property
AlterFulltextCatalog Property
AlterFulltextIndex Property
AlterFulltextStoplist Property
AlterFunction Property
AlterIndex Property
AlterInstance Property
AlterLinkedServer Property
AlterLogin Property
AlterMasterKey Property
AlterMessage Property
AlterMessageType Property
AlterPartitionFunction Property
AlterPartitionScheme Property
AlterPlanGuide Property
AlterProcedure Property
AlterQueue Property
AlterRemoteServer Property
AlterRemoteServiceBinding Property
AlterResourceGovernorConfig Property
AlterResourcePool Property
AlterRole Property
AlterRoute Property
AlterSchema Property
AlterSearchPropertyList Property
AlterSequence Property
AlterServerAudit Property
AlterServerAuditSpecification Property
AlterServerRole Property
AlterService Property
AlterServiceMasterKey Property
AlterSymmetricKey Property
AlterTable Property
AlterTrigger Property
AlterUser Property
AlterView Property
AlterWorkloadGroup Property
AlterXmlSchemaCollection Property
BindDefault Property
BindRule Property
CreateApplicationRole Property
CreateAssembly Property
CreateAsymmetricKey Property
CreateAvailabilityGroup Property
CreateBrokerPriority Property
CreateCertificate Property
CreateContract Property
CreateCredential Property
CreateCryptographicProvider Property
CreateDatabase Property
CreateDatabaseAuditSpecification Property
CreateDatabaseEncryptionKey Property
CreateDefault Property
CreateEndpoint Property
CreateEventNotification Property
CreateEventSession Property
CreateExtendedProcedure Property
CreateExtendedProperty Property
CreateFulltextCatalog Property
CreateFulltextIndex Property
CreateFulltextStoplist Property
CreateFunction Property
CreateIndex Property
CreateLinkedServer Property
CreateLinkedServerLogin Property
CreateLogin Property
CreateMasterKey Property
CreateMessage Property
CreateMessageType Property
CreatePartitionFunction Property
CreatePartitionScheme Property
CreatePlanGuide Property
CreateProcedure Property
CreateQueue Property
CreateRemoteServer Property
CreateRemoteServiceBinding Property
CreateResourcePool Property
CreateRole Property
CreateRoute Property
CreateRule Property
CreateSchema Property
CreateSearchPropertyList Property
CreateSequence Property
CreateServerAudit Property
CreateServerAuditSpecification Property
CreateServerRole Property
CreateService Property
CreateSpatialIndex Property
CreateStatistics Property
CreateSymmetricKey Property
CreateSynonym Property
CreateTable Property
CreateTrigger Property
CreateType Property
CreateUser Property
CreateView Property
CreateWorkloadGroup Property
CreateXmlIndex Property
CreateXmlSchemaCollection Property
DenyDatabase Property
DenyServer Property
DropApplicationRole Property
DropAssembly Property
DropAsymmetricKey Property
DropAvailabilityGroup Property
DropBrokerPriority Property
DropCertificate Property
DropContract Property
DropCredential Property
DropCryptographicProvider Property
DropDatabase Property
DropDatabaseAuditSpecification Property
DropDatabaseEncryptionKey Property
DropDefault Property
DropEndpoint Property
DropEventNotification Property
DropEventSession Property
DropExtendedProcedure Property
DropExtendedProperty Property
DropFulltextCatalog Property
DropFulltextIndex Property
DropFulltextStoplist Property
DropFunction Property
DropIndex Property
DropLinkedServer Property
DropLinkedServerLogin Property
DropLogin Property
DropMasterKey Property
DropMessage Property
DropMessageType Property
DropPartitionFunction Property
DropPartitionScheme Property
DropPlanGuide Property
DropProcedure Property
DropQueue Property
DropRemoteServer Property
DropRemoteServiceBinding Property
DropResourcePool Property
DropRole Property
DropRoleMember Property
DropRoute Property
DropRule Property
DropSchema Property
DropSearchPropertyList Property
DropSequence Property
DropServerAudit Property
DropServerAuditSpecification Property
DropServerRole Property
DropServerRoleMember Property
DropService Property
DropSignature Property
DropSignatureSchemaObject Property
DropStatistics Property
DropSymmetricKey Property
DropSynonym Property
DropTable Property
DropTrigger Property
DropType Property
DropUser Property
DropView Property
DropWorkloadGroup Property
DropXmlSchemaCollection Property
GrantDatabase Property
GrantServer Property
Logon Property
Rename Property
RevokeDatabase Property
RevokeServer Property
UnbindDefault Property
UnbindRule Property
UpdateStatistics Property
Expand Minimize

ServerDdlTriggerEvent.DropDatabaseEncryptionKey Property

SQL Server 2014

Gets a database data definition language (DDL) trigger event that can be included in the event set.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

C#
C++
F#
JScript
VB
Copy 
public static ServerDdlTriggerEvent DropDatabaseEncryptionKey { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.ServerDdlTriggerEvent
A ServerDdlTriggerEvent object that represents the DropDatabaseEncryptionKey event that can be included in the server DDL trigger event set.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft