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
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