Trigger (DML) Properties
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.)