what is difference between delete and truncate commands in sql June 09, 2012 By using truncate command we can delete all the records in a table , but we cant delete a single record in a table. by using delete command we can delete a entire records or a specified record in a table. Read more