📊 Day 7 – Data Analyst Most Asked Interview Question ❓

DELETE vs TRUNCATE vs DROP (SQL)

━━━━━━━━━━━━━━

DELETE

• Removes specific rows using WHERE
• Can be rolled back (transactional)
• Table structure remains
• Slower for large data

TRUNCATE

• Removes all rows at once
• Cannot be rolled back
• Table structure remains
• Faster than DELETE

DROP

• Removes entire table
• Deletes data + structure
• Cannot be rolled back
• Frees storage completely

━━━━━━━━━━━━━━

Rule:

👉 Remove specific data → DELETE
👉 Clear entire table fast → TRUNCATE
👉 Remove table completely → DROP ✅

━━━━━━━━━━━━━━

❤️ React ❤️ if you want interview prep Day 8 Tomorrow 🔥