In SQL Server, there are two categories of triggers: DDL Triggers and DML Triggers.
DDL Triggers are fired in response to Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords
DML Triggers are fired in response to Data Manipulation Language (DML) events. These events corresponds to Transact-SQL statements that start with the keywords
DML triggers are classified into two main types:
After Triggers (for triggers)
Instead of triggers