Advertisements
Advertisements
प्रश्न
Differentiate between delete and drop table command.
फरक स्पष्ट करा
Advertisements
उत्तर
| 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
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
