---
title: "what is different between delete and truncate"  
description: "what is different between delete and truncate"  
author: "shailesh tiwari"  
published: 2015-09-28  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/22844/what-is-different-between-delete-and-truncate  
category: "database"  
tags: ["sql"]  
reading_time: 1 minute  

---

# what is different between delete and truncate

delete command deletes the data which can be restore by usin commit or rollback command.Truncate deletes permanently data which can not be restore

## Answers

### Answer by shailesh tiwari

delete command deletes the data which can be restore by usin commit or rollback command.Truncate deletes permanently data which can not be restore


---

Original Source: https://www.mindstick.com/interview/22844/what-is-different-between-delete-and-truncate

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.