DROP DATABASE Statement 💣

Prerequisites: CREATE DATABASE

Mentor's Note: This is the "Nuclear Option". When you Drop a database, it's gone. The tables, the data, the users—everything inside it evaporates. Use with extreme caution! ⚠️

---

🌟 The Scenario: Demolition Day 🏗️

Imagine you built a prototype house. - You are done with it. You don't want to just empty the rooms; you want the land back. - DROP DATABASE is the wrecking ball. It clears the plot completely.

---

💻 1. The Basic Syntax

DROP DATABASE database_name;

Example: Deleting an Old Test DB

DROP DATABASE test_db_v1;

---

💻 2. Safe Deletion (Preventing Errors)

If you try to drop a database that doesn't exist, SQL will throw an error. Use IF EXISTS to handle this gracefully.

-- ✅ Best Practice
DROP DATABASE IF EXISTS old_project_db;

---

⚠️ Critical Warning

THERE IS NO UNDO. Unless you have a backup (which we cover in the Backup Guide), a dropped database cannot be recovered.

Safety Check: Always run a SELECT query or check your connection string to ensure you are dropping the Development database, not the Production one!

---

📈 Learning Path

• ← Back: Create Database
• Next: CREATE TABLE →