What is the difference between a DDL trigger and a DML trigger?
Ask by Sumit Kesarwani
Updated 24 Sep 2020
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).