⟩ How To List All Triggers in the Database with sys.triggers in MS SQL Server?
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 GlobalGuideLineDatabase;
GO
CREATE TRIGGER new_user ON ggl_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 GlobalGuideLineDatabase.
