Greenway Health Interview Question: What's the difference between TRUNCATE and DELETE

Notifications

Greenway Health

What's the difference between TRUNCATE and DELETE

Anonymous

20 Jun 2017

Both delete the data but Delete is a DML command can roll back but Truncate is a DDL command and don’t roll back and faster than DML

Anonymous

7 Mar 2012

one gets logged, the other doesn't so you have your performance hit. Need elevated permissions i.e. dbo for TRUNCATE