IMutableDmlTrigger Interface

  • Article

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 Delete Gets or sets a value that indicates whether the DML trigger activates on a DELETE statement.
Public property DeleteActivationOrder Gets or sets the ActivationOrder value that specifies activation order for DELETE event.
Public property ExecutionContext Gets or sets an IExecutionContext object that specifies the module execution context. (Inherited from IMutableTrigger.)
Public property Insert Gets or sets a value that indicates whether the DML trigger activates on an INSERT statement.
Public property InsertActivationOrder Gets or sets the ActivationOrder value that specifies activation order for INSERT event.
Public property InsteadOf Gets or sets a value that indicates whether the DML trigger executes instead of the triggering Transact-SQL statement.
Public property IsEnabled Gets or sets a value that indicates whether the module is enabled. (Inherited from IMutableTrigger.)
Public property IsEncrypted Gets or sets a value that indicates whether the module is encrypted. (Inherited from IMutableTrigger.)
Public property IsQuotedIdentifierOn Gets or sets 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 or sets a value that indicates whether this is a CLR module. (Inherited from IMutableTrigger.)
Public property Name Gets the name of the metadata object. (Inherited from IMetadataObject.)
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 or sets a value that indicates whether the DML trigger is activated on an UPDATE statement.
Public property UpdateActivationOrder Gets or sets 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