Sollicitatievraag bij Greenway Health

What's the difference between TRUNCATE and DELETE

Antwoorden op sollicitatievragen

Anoniem

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

Anoniem

7 mrt 2012

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

1