Collections:
sys.trigger_events - Event List of an Existing Trigger in SQL Server
How To See the Event List of an Existing Trigger using sys.trigger_events in SQL Server?
✍: FYIcenter.com
If what are the DML events an existing trigger 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:
USE FyiCenterData GO 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 GO 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.
⇒ "INSERTED" - New Record of an DML Event Instance in SQL Server
⇐ Creating Triggers for INSERT Statements Only in SQL Server
2016-10-24, 2218🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...