---
title: "What is the difference among \"dropping a table\", \"truncating a table\" and \"deleting all records\" from a table."  
description: "What is the difference among \"dropping a table\", \"truncating a table\" and \"deleting all records\" from a table."  
author: "Amit Singh"  
published: 2011-05-05  
updated: 2020-09-16  
canonical: https://www.mindstick.com/interview/830/what-is-the-difference-among-dropping-a-table-truncating-a-table-and-deleting-all-records-from-a-table  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.

**Dropping :** (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes

**Truncating:** (Data alone deleted), Performs an automatic commit, Faster than delete

**Delete :** (Data alone deleted), Doesn’t perform automatic commit

## Answers

### Answer by Amit Singh

**Dropping :** (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes

**Truncating:** (Data alone deleted), Performs an automatic commit, Faster than delete

**Delete :** (Data alone deleted), Doesn’t perform automatic commit


---

Original Source: https://www.mindstick.com/interview/830/what-is-the-difference-among-dropping-a-table-truncating-a-table-and-deleting-all-records-from-a-table

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