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

Notifications

Greenway Health

What's the difference between TRUNCATE and DELETE

Anonymous

Jun 20, 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

Mar 7, 2012

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