Sollicitatievraag bij NTT DATA

Difference between Truncate and delete

Antwoord op sollicitatievraag

Anoniem

25 mrt 2021

Truncate can be used to delete the entire data of the table without maintaining the integrity of the table. On the other hand , delete statement can be used for deleting the specific data. We can't rollback the changes in truncate. We can rollback the chances in delete.