- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between DELETE and DROP in SQL
In this post, we will understand the difference between DELETE and DROP commands in SQL.
DELETE
It removes some or all of the tuples/records from a relation/table.
It is DML, i.e data manipulation language.
The ‘WHERE’ clause is used to add filter to it.
It can be rolled back since it works on data buffer.
Table’s memory space is not free if all records have been deleted using the ‘Delete’ Command.
It may encounter memory shortage.
DROP
It removes named elements of schema such as relations/table, constraints or the entire schema itself.
It is DDL, i.e data definition language.
It doesn’t use a ‘WHERE’ clause.
It can’t be rolled back, since it works directly on the data.
It frees the memory space.
It can result in memory fragmentation.
- Related Articles
- Difference between DELETE and DROP SQL
- Difference between Delete and truncate in sql query
- Difference between SQL and PL/SQL
- Difference Between SQL and T-SQL
- Difference between Static SQL and Dynamic SQL
- Difference Between T-SQL and PL-SQL
- Difference between Voltage Drop and Potential Difference
- Difference between SQL and NoSQL
- Difference between SQL(Structured Query Language) and T-SQL(Transact-SQL).
- Difference between Join and union in SQL
- Difference Between COMMIT and ROLLBACK in SQL
- Difference between MySQL and SQL Server
- Difference between Oracle and SQL Server
- Difference between ETL and ELT in SQL Server
- Difference between Inner and Outer join in SQL

Advertisements