This topic has not yet been rated - Rate this topic

DatabaseDdlTriggerEvent Class

SQL Server 2012

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

C++

JScript

public sealed class DatabaseDdlTriggerEvent

The DatabaseDdlTriggerEvent type exposes the following members.

Properties

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

Top

Methods

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

Top

Operators

	Name	Description
	Addition	Creates a database ddl trigger event set by performing an addition operation on two DatabaseDdlTriggerEvent objects.
	BitwiseOr	Creates a new database ddl trigger event set by performing a BitwiseOr operation on two DatabaseDdlTriggerEvent objects.
	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.

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.

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD