DROP_STATISTICS(7pg13)

💅 DROP STATISTICS — the "bye bestie" command

So this is straight out of the PostgreSQL 13.23 Documentation (section 7pg13, yes bestie we're in the man pages now), and honestly? It's giving cleanup era. ✨

---

🌸 NAME 🌸

DROP_STATISTICS — remove extended statistics. That's it, that's the vibe. You made stats objects, now you're deleting them. Closure. 🦋

---

✨ SYNOPSIS ✨

DROP STATISTICS [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Look at that syntax, it ate. 💅

---

🎀 DESCRIPTION 🎀

Okay so DROP STATISTICS removes statistics object(s) from the database. Boom, gone, no cap. 🔥

But here's the thing — you can't just be out here dropping stats that aren't yours. Only the statistics object's owner, the schema owner, or a superuser can drop a statistics object. That's the rules. Know your role, respect the role. 👑

---

💖 PARAMETERS 💖

• IF EXISTS — Do not throw an error if the statistics object does not exist. A notice is issued in this case. Basically it's the "no worries if not" of SQL — instead of screaming at you, it just quietly leaves a little notice. 🫶
• name — The name (optionally schema-qualified) of the statistics object to drop. You can be all public.something about it or just use the short name, your call bestie. 🌸
• CASCADE
• RESTRICT — These key words do not have any effect, since there are no dependencies on statistics. Yeah… they're literally just there for the aesthetic. They don't do anything. ✨ Nothing. Zero. Nada. But you can type them, and honestly? Slay for the consistency. 😭

---

💅 EXAMPLES 💅

Okay so say you wanna destroy two statistics objects in different schemas, and you don't want it to fail if they don't exist. Here's the move:

DROP STATISTICS IF EXISTS
    accounting.users_uid_creation,
    public.grants_user_role;

Two schemas, two stats objects, one command, zero drama. Main character energy. 👑

---

🦋 COMPATIBILITY 🦋

There is no DROP STATISTICS command in the SQL standard. So like… this is a PostgreSQL thing. It's exclusive. Iykyk. 🧚

---

👀 SEE ALSO 👀

• ALTER STATISTICS (ALTER_STATISTICS(7))
• CREATE STATISTICS (CREATE_STATISTICS(7))

Go read those too, bestie — the whole glow-up journey, from CREATE to ALTER to, well… here. 🌈⭐

---

Ngl, this one's short and sweet. No warnings, no gotchas, just vibes and a clean deletion. 💜

Signing off from the PostgreSQL 13.23 docs, dated 2025 — DROP STATISTICS(7), and that's a wrap. 🎀💖