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, 2309🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...