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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
