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.

AmitDiwan

Published on 25-Mar-2021 05:56:43

• Related Questions & Answers
• 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 SQL and NoSQL
• Difference between MySQL and SQL Server
• Difference between Oracle and SQL Server
• 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 ETL and ELT in SQL Server
• Difference between Inner and Outer join in SQL
• Difference between stored procedure and triggers in SQL