Diff between TRUNCATE and DELETE command The DELETE command is used to delete particular records from a table. The TRUNCATE command is used to delete the complete data from the table. delete is a DML command. Truncate is a DDL command delete works with the WHERE clause. Truncate not works with where clause Example: DELETE FROM employee WHERE emp_id = 2012; Example: TRUNCATE TABLE employee_temp