Trigger (DML) Properties

  • Article

Triggers are a special form of a stored procedure that is carried out automatically when data in a specified table is modified. Triggers are often created to enforce referential integrity or consistency among logically related data in different tables.

Note

The properties in this topic are ordered by category rather than alphabet.

  • Identity Category
    Expands to show the Name property.

  • Name
    Shows the name of the selected trigger.

  • Misc Category
    Expands to show the remaining properties.

  • Is Encrypted
    Shows if the trigger was created with an optional encryption parameter.

  • Assembly Name
    Shows the name of the assembly with which the object is associated. (Applies only to SQLCLR triggers.)

  • Assembly Version
    Shows the version number of the assembly. (Applies only to SQLCLR triggers.)

  • Code Access Permission
    Shows the access permission granted to the assembly. Can be Safe, External Access, or Unsafe. (Applies only to SQLCLR triggers.)

See Also

Other Resources

Properties in Visual Database Tools

Working with Triggers