How to list all the triggers with table name and schema In SQL Server DB?

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.

Reference

• Read more about sys.triggers at Microsoft Docs.