DROP_COLLATION(7pg18)

💖 DROP COLLATION 💖

okay bestie, welcome to the DROP COLLATION(7) page from the PostgreSQL 18.6 Documentation ✨ this is the part where we say bye-bye to a collation, and honestly? it's giving spring cleaning 🧹🦋

---

✨ NAME ✨

DROP_COLLATION — remove a collation 💅

---

🎀 SYNOPSIS 🎀

DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]

---

🌸 DESCRIPTION 🌸

so DROP COLLATION removes a previously defined collation. that's it, that's the job, she's out 👑

but listen — to be able to drop a collation, you must own the collation. no owning, no dropping, iykyk 🔐

---

💅 PARAMETERS 💅

• IF EXISTS — do not throw an error if the collation does not exist. a notice is issued in this case 📢 like, no drama, we just quietly note it and move on 🫶
• name — the name of the collation. the collation name can be schema-qualified 🗂️
• CASCADE — automatically drop objects that depend on the collation, and in turn all objects that depend on <em>those</em> objects (see Section 5.15). it's giving domino effect, and honestly it's a lot 💀🔥
• RESTRICT — refuse to drop the collation if any objects depend on it. this is the default. she's cautious, she's careful, she's the main character of self-preservation 🌈

ngl bestie, CASCADE does not play — it takes the whole friend group down with it. RESTRICT is the default for a reason 🚨

---

🌟 EXAMPLES 🌟

to drop the collation named german:

DROP COLLATION german;

periodt. she's gone 🎀

---

🦋 COMPATIBILITY 🦋

the DROP COLLATION command conforms to the SQL standard ✨ apart from the IF EXISTS option, which is a PostgreSQL extension — so that one's a little bonus treat from us to you 🍓

---

👑 SEE ALSO 👑

• ALTER COLLATION (ALTER_COLLATION(7))
• CREATE COLLATION (CREATE_COLLATION(7))

---

that's the whole page, bestie, you ate that 💖 go forth and drop responsibly — and remember, you gotta own it to drop it 💅✨

PostgreSQL 18.6 · 2026 · DROP COLLATION(7) — mwah, love u, bye 🫶🎀