Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - sys.trigger_events - Event List of an Existing Trigger
(Continued from previous topic...)
How To See the Event List of an Existing Trigger using sys.trigger_events?
If what are the DML events an existing tigger is handling,
you can use the catalog view, sys.trigger_events.
You need to join sys.trigger_events and sys.triggers to get a better list
as shown in this tutorial example:
SELECT t.name, e.type, e.type_desc
FROM sys.trigger_events AS e, sys.triggers AS t
WHERE e.object_id = t.object_id
name type type_desc
-------------- ------ ---------
dml_message 1 INSERT
dml_message 2 UPDATE
dml_message 3 DELETE
new_user 1 INSERT
(4 row(s) affected)
The list clearly shows that dml_message handles 3 events: INSERT, UPDATE and DELETE.
(Continued on next topic...)
- What Are Triggers?
- What Are the Basic Features of a Trigger?
- How To Create a Simple Table to Test Triggers?
- How To Create a DML Trigger using CREATE TRIGGER Statements?
- How To Test a DML Trigger?
- How To List All Triggers in the Database with sys.triggers?
- How To Modify Existing Triggers using "ALTER TRIGGER"?
- How To Delete Existing Triggers using "DROP TRIGGER"?
- How To Get the Definition of a Trigger Back?
- How To Disable Triggers using "DISABLE TRIGGER"?
- How To Create a Trigger for INSERT Only?
- How To See the Event List of an Existing Trigger using sys.trigger_events?
- How To Access the Inserted Record of an Event?
- How To Access the Deleted Record of an Event?
- How To Improve the Trigger to Handle NULL Values?
- What Happens to a Trigger with Multiple Affected Rows?
- How To Override DML Statements with Triggers?
- How To Create a DDL Trigger using "CREATE TRIGGER" Statements?
- Can You Roll Back the DDL Statement in a Trigger?
- Can You Create a Logon Trigger in SQL Server 2005 Express Edition?