DDL, DML and the ghost

Question

I know that TRUNCATE TABLE cannot be caught by delete triggers. From what I've read, it is considered a DDL statement.

What is very interesting is that it does not even appear in sys.sys.trigger_event_types, which means it cannot even be caught on db/server-level triggers.

Is that really so? Why, of all possible statements, only truncate is untriggerable?

Answer 1

Hi @George Menoutis ,

> Why, of all possible statements, only truncate is untriggerable?

Quote from MS document TRUNCATE TABLE (Transact-SQL).

Although a TRUNCATE TABLE statement is in effect a DELETE statement, it doesn't activate a trigger because the operation doesn't log individual row deletions.

Quote from the blog Difference between SQL Truncate and SQL Delete statements in SQL Server.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.