9.12.2012

DML Triggers vs DDL Triggers

Difference between DML Triggers and DDL Triggers


S.No
DML Triggers
DDL Triggers
1
Where it operates ?
Operates on INSERT, UPDATE and DELETE.
Where it operates ?
Operates on CREATE, DROP and ALTER.
2
Where it can be applied ?
Applied on Tables and views.
Where it can be applied ?
Applied on Databases and servers.
3
Whether it can be used as INSTEAD OF TRIGGERS ?
Can be used as INSTEAD OF TRIGGERS.
Whether it can be used as INSTEAD OF TRIGGERS ?
Cannot be used as INSTEAD OF TRIGGERS.
4
Whether Magic tables can be created ?
Creates INSERTED and DELETED tables.
Whether Magic tables can be created ?
Cannot create INSERTED and DELETED tables.
5
When it runs ?
DML triggers run either Before or After a T-SQL statement is completed .
When it runs ?
DDL triggers run only after a T-SQL statement is completed .

No comments:

Post a Comment