WHAT IS THE DIFFERENCE BETWEEN A DDL TRIGGER AND A DML TRIGGER?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
C# 
C#
 1040  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is the difference between a DDL trigger and a DML trigger?

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

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!