Contains a row for each object that is a trigger, with a type of TR or TA. DML trigger names are schema-scoped and, therefore, are visible in sys.objects. DDL trigger names are scoped by the parent entity and are only visible in this view.
The parent_class and name columns uniquely identify the trigger in the database.
Trigger name. DML trigger names are schema-scoped. DDL trigger names are scoped with respect to the parent entity.
Object identification number. Is unique within a database.
Class of the parent of the trigger.
0 = Database, for the DDL triggers.
1 = Object or column for the DML triggers.
Description of the parent class of the trigger.
ID of the parent of the trigger, as follows:
0 = Triggers that are database-parented triggers.
For DML triggers, this is the object_id of the table or view on which the DML trigger is defined.
TA = Assembly (CLR) trigger
TR = SQL trigger
Description of object type.
Date the trigger was created.
Date the object was last modified by using an ALTER statement.
Trigger created on behalf of the user by an internal SQL Server component.
Trigger is disabled.
Trigger was created as NOT FOR REPLICATION.
1 = INSTEAD OF triggers
0 = AFTER triggers.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.