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, 2219🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...