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.

	OBJECT_SCHEMA_NAME(parent_id) AS 'Schema',
	OBJECT_NAME(parent_id) AS 'Table',
	Name as 'Trigger'
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.


Leave your thoughts...

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