sys.triggers - Listing All Triggers in the Database in SQL Server

Q

How To List All Triggers in the Database with sys.triggers in SQL Server?

✍: FYIcenter.com

A

If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example:

USE FyiCenterData;
GO

CREATE TRIGGER new_user ON fyi_users
AFTER INSERT 
AS
  PRINT 'New users added.';
GO

SELECT * FROM sys.triggers
GO
name         object_id   parent_id   type type_desc   
------------ ----------- ----------- ---- ------------
dml_message  690101499   674101442   TR   SQL_TRIGGER 
new_user     706101556   674101442   TR   SQL_TRIGGER 

The result shows that there are 2 triggers defined in FyiCenterData.

 

Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-25, 740👍, 0💬