Share via

IDmlTrigger Interface

  • Article

Represents a SQL Server DML trigger.

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

Syntax

'Declaration
Public Interface IDmlTrigger _
    Inherits ITrigger, IMetadataObject
'Usage
Dim instance As IDmlTrigger

public interface IDmlTrigger : ITrigger, 
    IMetadataObject

public interface class IDmlTrigger : ITrigger, 
    IMetadataObject

type IDmlTrigger =  
    interface 
        interface ITrigger 
        interface IMetadataObject 
    end

public interface IDmlTrigger extends ITrigger, IMetadataObject

The IDmlTrigger type exposes the following members.

Properties

  Name Description
Public property BodyText Gets the Transact-SQL statements that define the module. (Inherited from ITrigger.)
Public property Delete Gets a value that indicates whether the DML trigger activates on a DELETE statement.
Public property DeleteActivationOrder Gets the ActivationOrder value that specifies the activation order for DELETE event.
Public property ExecutionContext Gets an IExecutionContext object that specifies the module execution context. (Inherited from ITrigger.)
Public property Insert Gets a value that indicates whether the DML trigger activates on an INSERT statement.
Public property InsertActivationOrder Gets the ActivationOrder value that specifies activation order for INSERT event.
Public property InsteadOf Gets a value that indicates whether the DML trigger executes instead of the triggering Transact-SQL statement.
Public property IsEnabled Gets a value that indicates whether the module is enabled. (Inherited from ITrigger.)
Public property IsEncrypted Gets a value that indicates whether the module is encrypted. (Inherited from ITrigger.)
Public property IsQuotedIdentifierOn Gets 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 property IsSqlClr Gets a value that indicates whether the module is a CLR module. (Inherited from ITrigger.)
Public property Name Gets the name of the metadata object. (Inherited from IMetadataObject.)
Public property NotForReplication Gets a value that indicates whether the DML trigger is available for replication.
Public property Parent Gets the ITableViewBase object that is the parent of this object.
Public property Update Gets a value that indicates whether the DML trigger activates on an UPDATE statement.
Public property UpdateActivationOrder Gets the ActivationOrder value that specifies activation order for UPDATE event.

Top

Methods

  Name Description
Public method Accept<T> Accepts a visit from the specified IMetadataObjectVisitor<T> object. (Inherited from IMetadataObject.)

Top

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace