Some time for documentation purposes, you may need to list all the triggers with its associated table and schema names in an SQL Server database. Here is a simple and quick query to get the list.
1 2 3 4 5 6 7 | SELECT OBJECT_SCHEMA_NAME(parent_id) AS 'Schema', OBJECT_NAME(parent_id) AS 'Table', Name as 'Trigger'FROM sys.triggersORDER BY 1, 2, 3 |
If you need to list the triggers associated with a specific table, then read this article.
Reference
- Read more about sys.triggers at Microsoft Docs.