SQL Server – DDL vs. DML Triggers
Similarities between DDL and DML triggers:
1. Both are created using similar T-SQL syntax
2. Both can run .NET code
3. You can create multiple DDL and/or DML triggers on an object
4. The trigger and the triggering statement run as part of the same transaction
5. Both type of triggers can be nested
Differences between DDL and DML triggers:
1. There are no INSTEAD OF DDL triggers, they are only executed after the triggering statement is completed.
3. DDL triggers captures information about the event that fired them using EVENTDATA() function.
Hope This Helps!