- Trending Categories
- Data Structure
- Operating System
- C Programming
- 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.
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.
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.
- 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