SQL Server List All Triggers

To list all triggers in a SQL Server, you query data from the sys.triggers view:

SELECT  
    name,
    is_instead_of_trigger
FROM 
    sys.triggers  
WHERE 
    type = 'TR';Code language: SQL (Structured Query Language) (sql)

The following picture shows the output: