Share via

  • Article

IMutableDmlTrigger Interface

Represents a mutable 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 IMutableDmlTrigger _
    Inherits IDmlTrigger, IMutableTrigger, ITrigger, IMutableMetadataObject,  _
    IMetadataObject
'Usage
Dim instance As IMutableDmlTrigger

public interface IMutableDmlTrigger : IDmlTrigger, 
    IMutableTrigger, ITrigger, IMutableMetadataObject, IMetadataObject

public interface class IMutableDmlTrigger : IDmlTrigger, 
    IMutableTrigger, ITrigger, IMutableMetadataObject, IMetadataObject

type IMutableDmlTrigger =  
    interface
        interface IDmlTrigger
        interface IMutableTrigger
        interface ITrigger
        interface IMutableMetadataObject
        interface IMetadataObject
    end

public interface IMutableDmlTrigger extends IDmlTrigger, IMutableTrigger, ITrigger, IMutableMetadataObject, IMetadataObject

The IMutableDmlTrigger type exposes the following members.

Properties

  Name Description
Public property BodyText Gets or sets the Transact-SQL statements that define the module. (Inherited from IMutableTrigger.)
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. (Inherited from IDmlTrigger.)
Public property Delete Gets or sets a value that indicates whether the DML trigger activates on a DELETE statement.
Public property ExecutionContext Gets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableTrigger.)
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. (Inherited from IDmlTrigger.)
Public property Insert Gets or sets a value that indicates whether the DML trigger activates on an INSERT statement.
Public property InsteadOf Gets a value that indicates whether the DML trigger executes instead of the triggering Transact-SQL statement. (Inherited from IDmlTrigger.)
Public property InsteadOf Gets or sets a value that indicates whether the DML trigger executes instead of the triggering Transact-SQL statement.
Public property IsEncrypted Gets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableTrigger.)
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 quoted identifier option is on. (Inherited from IDmlTrigger.)
Public property IsQuotedIdentifierOn Gets or sets a Boolean value that indicates whether the quoted identifier is on.
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. (Inherited from IDmlTrigger.)
Public property NotForReplication Gets or sets a value that indicates whether the trigger is available for replication.
Public property Parent Gets the ITableViewBase object that is the parent of this object. (Inherited from IDmlTrigger.)
Public property Update Gets a value that indicates whether the DML trigger activates on an UPDATE statement. (Inherited from IDmlTrigger.)
Public property Update Gets or sets a value that indicates whether the DML trigger is activated on an UPDATE statement.

Top

Methods

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

Top