Google News
logo
SQL - Interview Questions
What is the difference between DELETE and TRUNCATE?
The differences are:
 
The basic difference in both is DELETE command is DML command and the TRUNCATE command is DDL.

DELETE command is used to delete a specific row from the table whereas the TRUNCATE command is used to remove all rows from the table.

We can use the DELETE command with WHERE clause but cannot use the TRUNCATE command with it.
Advertisement