DROP_TEXT_SEARCH_DICTIONARY(7pg13)

💅 DROP_TEXT_SEARCH_DICTIONARY 💅

okay so bestie, this is the DROP_TEXT_SEARCH_DICTIONARY(7pg13) page — yes that whole mouthful — and it's genuinely just about yeeting a text search dictionary out of existence. that's it. that's the whole vibe. let's get into it 🎀

---

✨ NAME ✨

DROP_TEXT_SEARCH_DICTIONARY — remove a text search dictionary. bye bye dictionary, no cap 🫶

---

✨ SYNOPSIS ✨

DROP TEXT SEARCH DICTIONARY [ IF EXISTS ] name [ CASCADE | RESTRICT ]

look at her. so clean. so powerful. the way she just drops things 😭💜

---

✨ DESCRIPTION ✨

so DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. iconic behavior honestly. but listen — to run this command you must be the owner of the dictionary. not your friend, not your coworker, you. ownership check, periodt 👑

---

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the text search dictionary doesn't exist. instead a notice is issued in this case. so like, it's the chill "no worries if not" of SQL options 🌸
• name — the name (optionally schema-qualified) of an existing text search dictionary. yes bestie, schema-qualified is allowed, go off 💅
• CASCADE — automatically drop objects that depend on the text search dictionary, and in turn all objects that depend on those objects (see Section 5.14). it's giving domino effect, it's giving chain reaction 🔥
• RESTRICT — refuse to drop the text search dictionary if any objects depend on it. this is the default. she's cautious, she's sensible, she's the main character of defaults 🧚

---

✨ EXAMPLES ✨

remove the text search dictionary english:

DROP TEXT SEARCH DICTIONARY english;

⚠️ heads up bestie: this command will not succeed if there are any existing text search configurations that use the dictionary. add CASCADE to drop such configurations along with the dictionary. no cap, this is the part that gets people 💀

---

✨ COMPATIBILITY ✨

there is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard. so this is a PostgreSQL-only moment, iykyk 🌈⭐

---

✨ SEE ALSO ✨

• ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7))
• CREATE TEXT SEARCH DICTIONARY (CREATE_TEXT_SEARCH_DICTIONARY(7))

---

and that's the page, bestie! 🦋 this one's from PostgreSQL 13.23, dated 2025 — drop it like it's hot, and stay hydrated 💖🎀✨