Export (0) Print
Expand All

IDmlTrigger Interface

Represents a SQL Server DML trigger.

Namespace:  Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public interface IDmlTrigger : ITrigger, 
	IMetadataObject

The IDmlTrigger type exposes the following members.

  NameDescription
Public propertyBodyTextGets the Transact-SQL statements that define the module. (Inherited from ITrigger.)
Public propertyDeleteGets a value that indicates whether the DML trigger activates on a DELETE statement.
Public propertyDeleteActivationOrderGets the ActivationOrder value that specifies the activation order for DELETE event.
Public propertyExecutionContextGets an IExecutionContext object that specifies the module execution context. (Inherited from ITrigger.)
Public propertyInsertGets a value that indicates whether the DML trigger activates on an INSERT statement.
Public propertyInsertActivationOrderGets the ActivationOrder value that specifies activation order for INSERT event.
Public propertyInsteadOfGets a value that indicates whether the DML trigger executes instead of the triggering Transact-SQL statement.
Public propertyIsEnabledGets a value that indicates whether the module is enabled. (Inherited from ITrigger.)
Public propertyIsEncryptedGets a value that indicates whether the module is encrypted. (Inherited from ITrigger.)
Public propertyIsQuotedIdentifierOnGets a value that indicates whether the identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
Public propertyIsSqlClrGets a value that indicates whether the module is a CLR module. (Inherited from ITrigger.)
Public propertyNameGets the name of the metadata object. (Inherited from IMetadataObject.)
Public propertyNotForReplicationGets a value that indicates whether the DML trigger is available for replication.
Public propertyParentGets the ITableViewBase object that is the parent of this object.
Public propertyUpdateGets a value that indicates whether the DML trigger activates on an UPDATE statement.
Public propertyUpdateActivationOrderGets the ActivationOrder value that specifies activation order for UPDATE event.
Top

  NameDescription
Public methodAccept<T>Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft