Listing All Triggers of ALL Databases in SQL Server

In this blog we see, How to list all the Triggers from all the database in sql server.

? – Indicates the name of database.

This will iterate all the database in the sql server and list the sys Triggers as section based on the database.

sp_msforeachdb 'select "?" AS dbName, * from [?].sys.triggers

You can also use like below,

select * from [DatabaseName].sys.triggers

Thanks for reading this article. Have a nice day.