---
title: "What is the difference between a DDL trigger and a DML trigger?"  
description: "What is the difference between a DDL trigger and a DML trigger?"  
author: "Sumit Kesarwani"  
published: 2013-12-29  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/1870/what-is-the-difference-between-a-ddl-trigger-and-a-dml-trigger  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# 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, DROP).

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

## Answers

### Answer by Sumit Kesarwani

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


---

Original Source: https://www.mindstick.com/interview/1870/what-is-the-difference-between-a-ddl-trigger-and-a-dml-trigger

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.