Advertisements
Advertisements
Question
Differentiate between delete and drop table command.
Distinguish Between
Advertisements
Solution
| Basis of Difference | DELETE | DROP TABLE |
|---|---|---|
| Purpose | Removes rows | Removes the complete table |
| Structure | Preserved | Deleted |
| WHERE clause | Can be used | Not applicable |
| Type | DML command | DDL command |
| Recovery | Can generally be rolled back before commit | Table must be recreated |
shaalaa.com
Is there an error in this question or solution?
