Labels

Sunday, 27 December 2015

SQL Server - Difference between DML Triggers and DDL Triggers

The below are the key differences between DML Triggers and DDL Triggers

S.No          DML Triggers                              DDL Triggers

1      DML Triggers will works on Insert    DDL Triggers will works on
        Update and Delete                               Create , Alter and Drop

2      DML Triggers will works on             DDL Triggers will works on
        Tables and Views                               Database and  and Servers

3     DML Triggers can be used as             DDL Triggers cannot be used
       Instead of Triggers                               as instead of triggers

4     DML Triggers will creates              
       Inserted and Deleted magic                     NA
       tables

5     DML Triggers runs either before       DDL Triggers run only after a
       or after a T-SQL statement is             T-SQL statement is completed .
       completed

No comments:

Post a Comment