• Article

DatabaseDdlTriggerEvent Class

The DatabaseDdlTriggerEvent object represents the SQL Server database DDL trigger events that can be included in a database DDL trigger event set.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerEvent

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

Syntax

'Declaration
Public NotInheritable Class DatabaseDdlTriggerEvent
'Usage
Dim instance As DatabaseDdlTriggerEvent

public sealed class DatabaseDdlTriggerEvent

public ref class DatabaseDdlTriggerEvent sealed

[<SealedAttribute>]
type DatabaseDdlTriggerEvent =  class end

public final class DatabaseDdlTriggerEvent

The DatabaseDdlTriggerEvent type exposes the following members.

Properties

  Name Description
Public propertyStatic member AddRoleMember Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AddSignature Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AddSignatureSchemaObject Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterApplicationRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterAssembly Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterAsymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterAuthorizationDatabase Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterBrokerPriority Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterCertificate Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterDatabaseAuditSpecification Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterDatabaseEncryptionKey Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterExtendedProperty Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterFulltextCatalog Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterFulltextIndex Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterFulltextStoplist Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterFunction Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterIndex Gets a database DDL trigger event that can be included in the event set
Public propertyStatic member AlterMasterKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterMessageType Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterPartitionFunction Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterPartitionScheme Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterPlanGuide Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterProcedure Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterQueue Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterRemoteServiceBinding Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterRoute Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterSchema Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterService Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterSymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterTable Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterTrigger Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterUser Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterView Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member AlterXmlSchemaCollection Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member BindDefault Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member BindRule Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateApplicationRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateAssembly Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateAsymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateBrokerPriority Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateCertificate Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateContract Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateDatabaseAuditSpecification Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateDatabaseEncryptionKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateDefault Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateEventNotification Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateExtendedProperty Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextCatalog Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateFulltextStoplist Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateFunction Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateMasterKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateMessageType Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreatePartitionFunction Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreatePartitionScheme Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreatePlanGuide Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateProcedure Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateQueue Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateRemoteServiceBinding Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateRoute Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateRule Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateSchema Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateService Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateSpatialIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateStatistics Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateSymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateSynonym Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateTable Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateTrigger Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateType Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateUser Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateView Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateXmlIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member CreateXmlSchemaCollection Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DenyDatabase Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropApplicationRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropAssembly Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropAsymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropBrokerPriority Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropCertificate Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropContract Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropDatabaseAuditSpecification Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropDatabaseEncryptionKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropDefault Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropEventNotification Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropExtendedProperty Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropFulltextCatalog Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropFulltextIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropFulltextStoplist Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropFunction Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropIndex Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropMasterKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropMessageType Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropPartitionFunction Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropPartitionScheme Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropPlanGuide Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropProcedure Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropQueue Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropRemoteServiceBinding Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropRole Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropRoleMember Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropRoute Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropRule Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropSchema Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropService Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropSignature Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropSignatureSchemaObject Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropStatistics Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropSymmetricKey Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropSynonym Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropTable Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropTrigger Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropType Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropUser Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropView Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member DropXmlSchemaCollection Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member GrantDatabase Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member Rename Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member RevokeDatabase Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member UnbindDefault Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member UnbindRule Gets a database DDL trigger event that can be included in the event set.
Public propertyStatic member UpdateStatistics Gets a database DDL trigger event that can be included in the event set.

Top

Methods

  Name Description
Public methodStatic member Add Returns a DatabaseDdlTriggerEventSet that is created by adding two DatabaseDdlTriggerEventobjects together.
Public methodStatic member BitwiseOr Creates a new database ddl trigger event set by performing a BitwiseOr operation on two DatabaseDdlTriggerEvent objects.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ToString Returns a string representation of the DatabaseDdlTriggerEvent. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a database ddl trigger event set by performing an addition operation on two DatabaseDdlTriggerEvent objects.
Public operatorStatic member BitwiseOr Creates a new database ddl trigger event set by performing a BitwiseOr operation on two DatabaseDdlTriggerEvent objects.
Public operatorStatic member Implicit(DatabaseDdlTriggerEvent to DatabaseDdlTriggerEventSet) Creates a database ddl trigger event set by performing an implicit operation on a DatabaseDdlTriggerEvent object.

Top

Remarks

The DatabaseDdlTriggerEvent object contains a property for each event to which the database DDL trigger can respond. The actual set of events is specified by using the DatabaseDdlTriggerEventSet object.

Thread Safety

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.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.