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:
Was this tutorial helpful?