Describe the difference between truncate and delete Technology Community › Category: SQL › Describe the difference between truncate and delete 0 Vote Up Vote Down VietMX Staff asked 4 years ago Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.