Share via

ISql90DmlTrigger Interface

  • Article

Models a Data Manipulation Language (DML) trigger.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Interface ISql90DmlTrigger _
    Inherits ISql90Trigger, ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined,  _
    ISqlDmlTrigger, ISqlTrigger, IModelNamed, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls,  _
    ISqlSpecifiesQuotedIdentifier, ISql90Signable, ISqlModelElement, IScriptSourcedModelElement, IModelElement,  _
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface ISql90DmlTrigger : ISql90Trigger, 
    ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISqlDmlTrigger, ISqlTrigger, 
    IModelNamed, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISql90Signable, 
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, 
    IModelAnnotationHolder

public interface class ISql90DmlTrigger : ISql90Trigger, 
    ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISqlDmlTrigger, ISqlTrigger, 
    IModelNamed, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISql90Signable, 
    ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, 
    IModelAnnotationHolder

type ISql90DmlTrigger =  
    interface
        interface ISql90Trigger
        interface ISql90SpecifiesExecutionContext
        interface ISql90ClrMethodDefined
        interface ISql90ClrClassDefined
        interface ISqlDmlTrigger
        interface ISqlTrigger
        interface IModelNamed
        interface ISqlExtendedPropertyHost
        interface ISqlSpecifiesAnsiNulls
        interface ISqlSpecifiesQuotedIdentifier
        interface ISql90Signable
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISql90DmlTrigger extends ISql90Trigger, ISql90SpecifiesExecutionContext, ISql90ClrMethodDefined, ISql90ClrClassDefined, ISqlDmlTrigger, ISqlTrigger, IModelNamed, ISqlExtendedPropertyHost, ISqlSpecifiesAnsiNulls, ISqlSpecifiesQuotedIdentifier, ISql90Signable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql90DmlTrigger type exposes the following members.

Properties

  Name Description
Public property Assembly Gets or sets the assembly that defines this SQL Server SQL CLR class. (Inherited from ISql90ClrClassDefined.)
Public property BodyDependencies Gets the list of objects that are referenced in the script of the trigger. (Inherited from ISqlTrigger.)
Public property BodyScript Gets or sets the body of the trigger. (Inherited from ISqlTrigger.)
Public property ClassName Gets or sets the name of the SQL Server SQL CLR class. (Inherited from ISql90ClrClassDefined.)
Public property DeleteOrderRestriction Gets or sets a value that indicates when the trigger is executed, with regard to other triggers for the same DELETE operation. (Inherited from ISqlDmlTrigger.)
Public property DynamicObjects Gets the list of temporary column sources that are created in the trigger body. (Inherited from ISqlTrigger.)
Public property ElementClass Gets the metadata class for an element. (Inherited from IModelElement.)
Public property ExtendedProperties Gets the list of extended properties for this object. (Inherited from ISqlExtendedPropertyHost.)
Public property InsertOrderRestriction Gets or sets a value that indicates when the trigger is executed, with regard to other triggers for the same INSERT operation. (Inherited from ISqlDmlTrigger.)
Public property IsAnsiNullsOn Gets or sets a value that indicates whether the ANSI NULLS setting is ON for this object. (Inherited from ISqlSpecifiesAnsiNulls.)
Public property IsCaller Gets or sets a value that indicates whether the object is executed as the caller. (Inherited from ISql90SpecifiesExecutionContext.)
Public property IsDeleteTrigger Gets or sets a value that indicates whether the trigger is executed for DELETE operations. (Inherited from ISqlDmlTrigger.)
Public property IsDisabled Gets or sets a value that indicates whether the trigger is disabled. (Inherited from ISqlTrigger.)
Public property IsEncrypted Gets or sets a value that indicates whether the trigger is encrypted. (Inherited from ISqlTrigger.)
Public property IsInsertTrigger Gets or sets a value that indicates whether the trigger is executed for INSERT operations. (Inherited from ISqlDmlTrigger.)
Public property IsNotForReplication Gets or sets a value that indicates whether the trigger specified the NOT FOR REPLICATION option. (Inherited from ISqlDmlTrigger.)
Public property IsOwner Gets or sets a value that indicates whether the object is executed as its owner. (Inherited from ISql90SpecifiesExecutionContext.)
Public property IsQuotedIdentifierOn Gets or sets a value that indicates whether the QUOTED IDENTIFIER setting is ON for this object. (Inherited from ISqlSpecifiesQuotedIdentifier.)
Public property IsSelf Gets or sets a value that indicates whether the object is executed as its creator. (Inherited from ISql90SpecifiesExecutionContext.)
Public property IsUpdateTrigger Gets or sets a value that indicates whether the trigger is executed for UPDATE operations. (Inherited from ISqlDmlTrigger.)
Public property IsWithAppend Gets or sets a value that indicates whether the trigger specified the WITH APPEND option. (Inherited from ISqlDmlTrigger.)
Public property Login Gets or sets the login as which to execute. (Inherited from ISql90SpecifiesExecutionContext.)
Public property MethodName Gets or sets the name of the SQL Server SQL CLR method. (Inherited from ISql90ClrMethodDefined.)
Public property Model Gets the model reference. (Inherited from IModelEntity.)
Public property Name Gets or sets the name of the element. (Inherited from IModelElement.)
Public property Parent Gets or sets the object to which the trigger applies. (Inherited from ISqlDmlTrigger.)
Public property PrimarySource Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.)
Public property ResolutionStatus Gets or sets the value of the model element resolution status. (Inherited from IModelElement.)
Public property SecondarySources Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.)
Public property Signatures Gets a list of the signatures that apply to this signable object. (Inherited from ISql90Signable.)
Public property SourceCodePositions Gets the list of sources that define this element. (Inherited from IModelElement.)
Public property SqlTriggerType Gets or sets a value that specifies the timing of the execution of the trigger. (Inherited from ISqlTrigger.)
Public property UpdateOrderRestriction Gets or sets a value that indicates when the trigger is executed, with regard to other triggers for the same UPDATE operation. (Inherited from ISqlDmlTrigger.)
Public property User Gets or sets the user as which to execute. (Inherited from ISql90SpecifiesExecutionContext.)
Public property ValidationStatus Gets or sets the value of the model element validation status. (Inherited from IModelElement.)

Top

Methods

  Name Description
Public method AddAnnotation Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
Public method Delete Deletes this instance from the model. (Inherited from IModelElement.)
Public method GetAnnotations() Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(Type) Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier) Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier, Type) (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>() Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>(ModelIdentifier) (Inherited from IModelAnnotationHolder.)
Public method GetAssemblyRelationship Returns an IModelSingleRelationship between this and the associated ISql90Assembly. (Inherited from ISql90ClrClassDefined.)
Public method GetBodyDependenciesRelationship Returns an IModelMultiRelationship between this and the associated IModelElement. (Inherited from ISqlTrigger.)
Public method GetComposingChildren Returns a list of composing children for this element. (Inherited from IModelElement.)
Public method GetDynamicObjectsRelationship Returns an IModelMultiRelationship between this and the associated ISqlDynamicColumnSource. (Inherited from ISqlTrigger.)
Public method GetExtendedPropertiesRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlExtendedProperty. (Inherited from ISqlExtendedPropertyHost.)
Public method GetHierarchicalChildren Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public method GetLoginRelationship Returns an IModelSingleRelationship between this and the associated ISql90Login. (Inherited from ISql90SpecifiesExecutionContext.)
Public method GetOwnerInfo Returns information about the element owner. (Inherited from IModelElement.)
Public method GetParentRelationship Returns an IModelSingleRelationship between this and the associated ISqlColumnSource. (Inherited from ISqlDmlTrigger.)
Public method GetProperty<TProperty> Gets the specified property. (Inherited from IModelPropertyContainer.)
Public method GetReferencedDanglingRelationshipEntries Returns a list of the relationship entries, where this element is on the left side and there is either no element on the right side of the relationship, or the element on the right does not exist in the model. (Inherited from IModelElement.)
Public method GetReferencedElements Returns a list of the elements that are in a relationship with this element, where this element is on the left side of the relationship. (Inherited from IModelElement.)
Public method GetReferencedRelationshipEntries Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method GetReferencingElements Returns a list of the elements that are in a relationship with this element, where this element is on the right side. (Inherited from IModelElement.)
Public method GetReferencingRelationshipEntries Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public method GetRelationship(ModelRelationshipClass) Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
Public method GetRelationship<TFrom, TTo>(ModelRelationshipClass) Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
Public method GetRelationshipEntrySources Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
Public method GetRelationships Returns a list of the relationships in this element. (Inherited from IModelElement.)
Public method GetSignaturesRelationship Returns an IModelReverseMultiRelationship between this and the associated ISql90Signature. (Inherited from ISql90Signable.)
Public method GetUserRelationship Returns an IModelSingleRelationship between this and the associated ISql90User. (Inherited from ISql90SpecifiesExecutionContext.)
Public method IsDeleted Specifies whether the object is deleted. (Inherited from IModelElement.)
Public method IsExternal Returns a value that indicates whether the object was loaded from an external source and is not a part of the schema model. (Inherited from IModelElement.)
Public method RemoveAnnotation Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
Public method SetProperty<TProperty> Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace