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.
SELECT OBJECT_SCHEMA_NAME(parent_id) AS 'Schema', OBJECT_NAME(parent_id) AS 'Table', Name as 'Trigger' FROM sys.triggers ORDER BY 1, 2, 3
If you need to list the triggers associated with a specific table, then read this article.
- Read more about sys.triggers at Microsoft Docs.