Viewing DDL Trigger Metadata by querying sys.triggers : 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 name TriggerNM, is_disabled
5> FROM sys.triggers
6> WHERE parent_class_desc = 'DATABASE'
7> ORDER BY OBJECT_NAME(parent_id), name
8> GO
TriggerNM
         is_disabled
------------------------------------------------------------------------------------------------------------------------
-------- -----------
db_trg
                   0
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