---
title: "What is the difference between TRUNCATE and DROP statements?"  
description: "What is the difference between TRUNCATE and DROP statements?"  
author: "Ravi Vishwakarma"  
published: 2021-09-22  
updated: 2021-09-22  
canonical: https://www.mindstick.com/forum/156745/what-is-the-difference-between-truncate-and-drop-statements  
category: "database"  
tags: ["database", "mysql", "sql server", "sql"]  
reading_time: 1 minute  

---

# What is the difference between TRUNCATE and DROP statements?

What is the [difference](https://www.mindstick.com/articles/157114/good-news-or-bad-news-and-the-difference-is) between [TRUNCATE](https://www.mindstick.com/blog/313/difference-between-truncate-delete-statement-in-sql-server) and [DROP](https://www.mindstick.com/forum/159392/how-to-fetch-the-value-of-the-selected-options-in-drop-down-in-php) statements?

## Replies

### Reply by Ashutosh Kumar Verma

## Different between TRUNCATE and DROP command:

## SQL TRUNCATE Command:

SQL Truncate command is used to permanently delete only records from a database table. to deleted records by using of truncate command can not be recovered or rollback because it is not stored in cache of the system.

![What is the difference between TRUNCATE and DROP statements?](https://www.mindstick.com/mindstickforums/82a9f814-9ab9-4b9c-a99e-774cf72a87a8/images/d15ba8f2-54a2-48de-8e8f-64190f88a087.png) **\**

The following SQL statement is delete records from above table using of Truncate command.

![What is the difference between TRUNCATE and DROP statements?](https://www.mindstick.com/mindstickforums/82a9f814-9ab9-4b9c-a99e-774cf72a87a8/images/b4bc1951-1025-4858-a1f3-920ea3eccce4.png)

## SQL DROP Command:

The SQL DROP command is used to delete whole table with records or used to delete a database.

The following SQL statement used to drop the table 'TeacherDetails'

![What is the difference between TRUNCATE and DROP statements?](https://www.mindstick.com/mindstickforums/82a9f814-9ab9-4b9c-a99e-774cf72a87a8/images/bebeaf8e-e2d5-4c2c-942d-b3ecba2b22ca.png)

To drop the database you should use the following SQL command

```
drop database_name ;
```

\


---

Original Source: https://www.mindstick.com/forum/156745/what-is-the-difference-between-truncate-and-drop-statements

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