DROP_TEXT_SEARCH_TEMPLATE(7pg13)

💅 DROP_TEXT_SEARCH_TEMPLATE — remove a text search template ✨

okay bestie, this is the PostgreSQL 13.23 page for DROP_TEXT_SEARCH_TEMPLATE, and it's honestly such a niche icon. it's the DROP TEXT SEARCH TEMPLATE command, and it does exactly one thing: yeets an existing text search template out of existence. no cap. 🗑️✨

🚨 real talk first: you must be a superuser to use this command. like, this is not a vibe check you can just wander into. superuser only. periodt.

---

🎀 SYNOPSIS 🎀

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

---

🌸 DESCRIPTION 🌸

DROP TEXT SEARCH TEMPLATE drops an existing text search template. that's the whole gig. the way that it just… removes it. 💀

and again, because it bears repeating: you must be a superuser to use this command. not optional, not negotiable, not "well i know the password"—superuser. 👑

---

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the text search template doesn't exist. instead, a notice is issued. so thoughtful 🫶 it's giving "no drama, just a little heads up."
• name — the name (optionally schema-qualified) of an existing text search template. yes bestie, schema-qualified is allowed, live your life 💖
• CASCADE — automatically drop objects that depend on the text search template, and in turn all objects that depend on those objects (see Section 5.14). it's the chain reaction option 🔥 domino effect energy.
• RESTRICT — refuse to drop the text search template if any objects depend on it. This is the default. so if you don't say anything, it's gonna be protective and say no 🙈 iconic boundary-setting honestly.

---

🦋 EXAMPLES 🦋

remove the text search template thesaurus:

DROP TEXT SEARCH TEMPLATE thesaurus;

okay so heads up: this command will not succeed if there are any existing text search dictionaries that use the template. 😭 it's not being difficult, it's just got attachments.

add CASCADE to drop such dictionaries along with the template. one clean sweep, no leftover messes 🧹✨

---

🌈 COMPATIBILITY 🌈

there is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard. so like... this is a PostgreSQL original, main character energy only 👑💅

---

💜 SEE ALSO 💜

• ALTER TEXT SEARCH TEMPLATE (ALTER_TEXT_SEARCH_TEMPLATE(7))
• CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7))

---

🌸 mwah, that's the page! this lil masterpiece is from PostgreSQL 13.23, dated 2025, and honestly? she ate. go drop those templates responsibly bestie 🫶💖🎀