Home > DeveloperSection > Interviews > What is the difference between a DDL trigger and a DML trigger?

Posted on    December-29-2013 10:47 PM

 C# C# 
Ratings:
 1 Answer(s)
  1979  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    December-29-2013 1:00 AM

A DDL trigger executes in response to a change to the structure of a database (for example, CREATE, ALTER, DROP).

A DML trigger executes in response to a change in data (INSERT, UPDATE, DELETE).

Don't want to miss updates? Please click the below button!

Follow MindStick