Home >> FAQs/Tutorials >> SQL Server FAQ

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

By: FYIcenter.com

(Continued from previous topic...)

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

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.

(Continued on next topic...)

1. What Are Triggers?
2. What Are the Basic Features of a Trigger?
3. How To Create a Simple Table to Test Triggers?
4. How To Create a DML Trigger using CREATE TRIGGER Statements?
5. How To Test a DML Trigger?
6. How To List All Triggers in the Database with sys.triggers?
7. How To Modify Existing Triggers using "ALTER TRIGGER"?
8. How To Delete Existing Triggers using "DROP TRIGGER"?
9. How To Get the Definition of a Trigger Back?
10. How To Disable Triggers using "DISABLE TRIGGER"?
11. How To Create a Trigger for INSERT Only?
12. How To See the Event List of an Existing Trigger using sys.trigger_events?
13. How To Access the Inserted Record of an Event?
14. How To Access the Deleted Record of an Event?
15. How To Improve the Trigger to Handle NULL Values?
16. What Happens to a Trigger with Multiple Affected Rows?
17. How To Override DML Statements with Triggers?
18. How To Create a DDL Trigger using "CREATE TRIGGER" Statements?
19. Can You Roll Back the DDL Statement in a Trigger?
20. Can You Create a Logon Trigger in SQL Server 2005 Express Edition?