DatabaseDdlTriggerEventSet Class

The DatabaseDdlTriggerEventSet object represents a set of SQL Server database data definition language (DDL) trigger events. 

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerEventSet

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

Syntax

'Declaration
Public NotInheritable Class DatabaseDdlTriggerEventSet _
    Inherits EventSetBase
'Usage
Dim instance As DatabaseDdlTriggerEventSet
public sealed class DatabaseDdlTriggerEventSet : EventSetBase
public ref class DatabaseDdlTriggerEventSet sealed : public EventSetBase
[<SealedAttribute>]
type DatabaseDdlTriggerEventSet =  
    class 
        inherit EventSetBase 
    end
public final class DatabaseDdlTriggerEventSet extends EventSetBase

The DatabaseDdlTriggerEventSet type exposes the following members.

Constructors

  Name Description
Public method DatabaseDdlTriggerEventSet() Initializes a new instance of the DatabaseDdlTriggerEventSet class.
Public method DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEvent) Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
Public method DatabaseDdlTriggerEventSet(array<DatabaseDdlTriggerEvent[]) Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.
Public method DatabaseDdlTriggerEventSet(DatabaseDdlTriggerEventSet) Initializes a new instance of the DatabaseDdlTriggerEventSet class with a specified event.

Top

Properties

  Name Description
Public property AddRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AddSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AddSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is altered.
Public property AlterAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is altered.
Public property AlterAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterAuthorizationDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an authorization database is altered.
Public property AlterBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is altered.
Public property AlterDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is altered.
Public property AlterFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is altered.
Public property AlterIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is altered.
Public property AlterMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is altered.
Public property AlterPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is altered.
Public property AlterPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is altered.
Public property AlterPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is altered.
Public property AlterQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is altered.
Public property AlterRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is altered.
Public property AlterRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is altered.
Public property AlterRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is altered.
Public property AlterSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is altered.
Public property AlterSearchPropertyList Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterSequence Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is altered.
Public property AlterSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property AlterTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is altered.
Public property AlterTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is altered.
Public property AlterUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is altered.
Public property AlterView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is altered.
Public property AlterXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is altered.
Public property BindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property BindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is created.
Public property CreateAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is created.
Public property CreateAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is created.
Public property CreateDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is created.
Public property CreateDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is created.
Public property CreateExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is created.
Public property CreateFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is created.
Public property CreateIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is created.
Public property CreateMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is created.
Public property CreatePartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is created.
Public property CreatePartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is created.
Public property CreatePlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is created.
Public property CreateQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker queue is created.
Public property CreateRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is created.
Public property CreateRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is created.
Public property CreateRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is created.
Public property CreateRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is created.
Public property CreateSearchPropertyList Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateSequence Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is created.
Public property CreateSpatialIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is created.
Public property CreateSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property CreateSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is created.
Public property CreateTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is created.
Public property CreateTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is created.
Public property CreateType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is created.
Public property CreateUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is created.
Public property CreateView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is created.
Public property CreateXmlIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML index is created.
Public property CreateXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is created.
Public property DdlApplicationRoleEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlAssemblyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlAsymmetricKeyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlAuthorizationDatabaseEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlBrokerPriorityEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlCertificateEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlContractEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlCryptoSignatureEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlDatabaseAuditSpecificationEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlDatabaseEncryptionKeyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlDatabaseLevelEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlDatabaseSecurityEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlDefaultEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlEventNotificationEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlExtendedPropertyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlFulltextCatalogEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlFulltextStoplistEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlFunctionEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlGdrDatabaseEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlIndexEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlMasterKeyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlMessageTypeEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlPartitionEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlPartitionFunctionEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlPartitionSchemeEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlPlanGuideEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlProcedureEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlQueueEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlRemoteServiceBindingEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlRoleEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlRouteEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlRuleEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSchemaEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSearchPropertyListEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSequenceEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlServiceEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSsbEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlStatisticsEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSymmetricKeyEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlSynonymEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlTableEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlTableViewEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlTriggerEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlTypeEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlUserEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlViewEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DdlXmlSchemaCollectionEventsEvents Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DenyDatabase Gets or sets a Boolean property value that specifies whether events are included in the event set.
Public property Dirty Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when data stored in the cache needs refreshing is encountered.
Public property DropApplicationRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an application role is dropped.
Public property DropAssembly Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an assembly is dropped.
Public property DropAsymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropBrokerPriority Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropCertificate Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropContract Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker contract is dropped.
Public property DropDatabaseAuditSpecification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database audit specification is dropped.
Public property DropDatabaseEncryptionKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropEventNotification Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an event notification is dropped.
Public property DropExtendedProperty Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextCatalog Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropFulltextStoplist Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text search, stop list is dropped.
Public property DropFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user-defined function is dropped.
Public property DropIndex Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an index is dropped.
Public property DropMasterKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropMessageType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a message type is dropped.
Public property DropPartitionFunction Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition function is dropped.
Public property DropPartitionScheme Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a partition scheme is dropped.
Public property DropPlanGuide Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropProcedure Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a stored procedure is dropped.
Public property DropQueue Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Service Broker queue is dropped.
Public property DropRemoteServiceBinding Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a remote service binding is dropped.
Public property DropRole Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database role is dropped.
Public property DropRoleMember Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropRoute Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker route is dropped.
Public property DropRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSchema Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a schema is dropped.
Public property DropSearchPropertyList Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSequence Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropService Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a Service Broker service is dropped.
Public property DropSignature Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSignatureSchemaObject Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statistics counter is dropped.
Public property DropSymmetricKey Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property DropSynonym Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a synonym is dropped.
Public property DropTable Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a table is dropped.
Public property DropTrigger Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a trigger is dropped.
Public property DropType Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a type is dropped.
Public property DropUser Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database user is dropped.
Public property DropView Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a view is dropped.
Public property DropXmlSchemaCollection Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an XML schema collection is dropped.
Public property GrantDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is granted to the database.
Public property NumberOfElements Gets the number of events that are included in the event set. (Overrides EventSetBase.NumberOfElements.)
Public property Rename Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property RevokeDatabase Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when access is revoked from the database.
Protected property Storage Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public property UnbindDefault Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property UnbindRule Gets or sets a Boolean property value that specifies whether the event is included in the event set.
Public property UpdateStatistics Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when statistics are updated.

Top

Methods

  Name Description
Public method Add(DatabaseDdlTriggerEvent) Returns a set of database DDL trigger events after adding a new event to the event referenced set.
Public methodStatic member Add(DatabaseDdlTriggerEventSet, DatabaseDdlTriggerEvent) Returns a set of database DDL trigger events after adding a new event to the event specified set.
Public method Copy Returns a copy of the event set. (Overrides EventSetBase.Copy().)
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method Remove Removes an event from the event set.
Public methodStatic member Subtract Returns a set of database DDL trigger events after removing an event from the event specified set.
Public method ToString Returns a string that represents the DatabaseDdlTriggerEventSet object. (Overrides Object.ToString().)

Top

Operators

  Name Description
Public operatorStatic member Addition Creates a database data definition language (DDL) trigger event set by performing an addition operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.
Public operatorStatic member Subtraction Creates a database data definition language (DDL) trigger event set by performing a subtraction operation on a DatabaseDdlTriggerEvent object and a DatabaseDdlTriggerEventSet object.

Top

Remarks

DDL triggers run a Transact-SQL or user-defined function in response to certain DDL events. The DatabaseDdlTriggerEventSet object contains a property for each event to which the database DDL trigger responds.

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.

Examples

Handling SMO Events

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.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace