DROP_CAST(7pg18)

💅 DROP CAST(7) — the PostgreSQL 18.6 era, bestie

okay so this is the PostgreSQL 18.6 Documentation page for DROP CAST, and we're gonna make it make sense. no cap.

---

✨ NAME ✨

DROP_CAST — remove a cast 🫶

---

🌸 SYNOPSIS 🌸

DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]

look at her. so clean. so simple. she's giving "one line, whole lotta power". 👑

---

🦋 DESCRIPTION 🦋

DROP CAST removes a previously defined cast. that's it. that's the whole job. she's a deleter, not a creator. 💀

but bestie, listen — to be able to drop a cast, you must own the source or the target data type. and here's the tea: those are the same privileges that are required to create a cast. so if you could make her, you can unmake her. it's giving symmetry. it's giving balance. ✨

not you having to actually own the type to do this... permissions really said "know your place" 😭

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the cast doesn't exist. instead, a notice is issued in this case. so like, she won't scream at you, she'll just quietly go "hmm, wasn't there anyway" 💅
• source_type — the name of the source data type of the cast. the "from" girlie. 🌈
• target_type — the name of the target data type of the cast. the "to" girlie. 🦋
• CASCADE
• RESTRICT — okay so these key words do not have any effect, since there are no dependencies on casts. they're literally just here for the vibes. decorative. ornamental. icons doing nothing but looking cute. 🎀✨

---

🔥 EXAMPLES 🔥

say you wanna drop the cast from type text to type int:

DROP CAST (text AS int);

periodt. done. she's gone. 💅

---

💜 COMPATIBILITY 💜

the DROP CAST command conforms to the SQL standard. she's certified. she's official. she passed the vibe check. ✅

---

👑 SEE ALSO 👑

• CREATE CAST (CREATE_CAST(7))

go make one, then come back and drop it. the full circle moment fr fr. 🔄

---

mwah 💖 that was the whole page, bestie — brought to you by PostgreSQL 18.6, dated 2026, and it's literally the same DROP CAST(7) energy from top to bottom. stay hydrated, back up your schemas, and never drop a cast you don't own. 🫶🌸