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
List All The Triggers With Table Name And Schema

If you need to list the triggers associated with a specific table, then read this article.

Reference


Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.