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, 2682🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...