How to list all Triggers in a SQL Server Database

To list all triggers in a SQL Server Database use this simple query:

USE Database_Name
SELECT * FROM sys.triggers

It will list all triggers (DML and DDL) in the database.

Here is the same query, with an added column called Parent_Object_Name which shows the table name for which the trigger was created (for DML triggers), and NULL for database (DDL) triggers:

USE Database_Name
SELECT OBJECT_NAME(parent_id) as Parent_Object_Name, *
FROM sys.triggers

List all Triggers in a SQL Server Database

To see how to disable and enable triggers in SQL Server, and how to get a list of triggers that are disabled or enabled read related article:
Disable and enable triggers in SQL Server

To see how to list all DML Triggers modified in last N days in a SQL Server Database:
List all DML Triggers modified in last N days in a SQL Server Database

To see how to list all DDL Triggers modified in last N days in a SQL Server Database:
List all DDL Triggers modified in last N days in a SQL Server Database

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">