Viewing DML Trigger Metadata: Show the DML triggers in the current database : sys.triggers « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sys.triggers
3>
4> SELECT OBJECT_NAME(parent_id) Table_or_ViewNM,
5> name TriggerNM, is_instead_of_trigger, is_disabled
6> FROM sys.triggers
7> WHERE parent_class_desc = 'OBJECT_OR_COLUMN'
8> ORDER BY OBJECT_NAME(parent_id), name
9> GO
Table_or_ViewNM
         TriggerNM
                  is_instead_of_trigger is_disabled
------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
----------------- --------------------- -----------
1>








27.19.sys.triggers
27.19.1.Viewing DDL Trigger Metadata by querying sys.triggers
27.19.2.Viewing DML Trigger Metadata: Show the DML triggers in the current database
27.19.3.Viewing DDL Trigger Metadata by joining sys.triggers and sys.sql_modules