Differentiate between TRUNCATE and DELETE commands in SQL.

Answer»

TRUNCATE	DELETE
It is used to remove all records from a database table	It is used to delete specified records(ONE or more) from a database table
It is a Data Definition Language(DDL) command	It is a Data Manipulation Language(DML) command
Faster than DELETE command	Slower compared to TRUNCATE command
Cannot be APPLIED for indexed views as it WORKS only on tables	Can be applied for indexed views

Discussion