DROP_COLLATION(7pg15)

💅 DROP_COLLATION 💅

okay bestie, this is the DROP_COLLATION page from the PostgreSQL 15.19 docs — manual name folded in, vibe check passed ✨. It’s all about removing a collation you previously defined. Let’s go 🫶

🗑️ NAME 🗑️

DROP_COLLATION — remove a collation 💅

✨ SYNOPSIS ✨

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

🌸 DESCRIPTION 🌸

DROP COLLATION removes a previously defined collation. That’s the whole main-character move 💖.

To be able to drop a collation, you must own the collation. no cap — ownership is the vibe check here 👑

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the collation does not exist. In that case, a notice is issued 👀.
• 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 those objects (see Section 5.14) 💥.
• RESTRICT — refuse to drop the collation if any objects depend on it. This is the default 🛑.

🦋 EXAMPLES 🦋

To drop the collation named german:

DROP COLLATION german;

slay, gone 💨

🌈 COMPATIBILITY 🌈

The DROP COLLATION command conforms to the SQL standard, apart from the IF EXISTS option, which is a PostgreSQL extension. periodt ✨

👑 SEE ALSO 👑

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

---

made with 💖 from PostgreSQL 15.19, dated 2026 — bye bestie, go drop those collations responsibly 🎀💅