Below is the difference between DELETE and TRUNCATE statement in SQL. The main differences between SQL DELETE and TRUNCATE statements are given below:
|1)||DELETE is a DML command.||TRUNCATE is a DDL command.|
|2)||We can use WHERE clause in DELETE command.||We cannot use WHERE clause with TRUNCATE|
|3)||DELETE statement is used to delete a row from a table||TRUNCATE statement is used to remove all the rows from a table.|
|4)||DELETE is slower than TRUNCATE statement.||TRUNCATE statement is faster than DELETE statement.|
|5)||You can rollback data after using DELETE statement.||It is not possible to rollback after using TRUNCATE statement.|
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.