DROP_DOMAIN(7pg13)

okay so bestie, welcome to the DROP DOMAIN(7) page from the PostgreSQL 13.23 Documentation 💖

✨ NAME ✨

DROP DOMAIN — remove a domain. That’s the whole name, no cap.

🦋 SYNOPSIS 🦋

Here’s the syntax, copy it exactly because syntax is not a vibe you freestyle:

DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

💅 DESCRIPTION 💅

So DROP DOMAIN removes a domain. Literally its whole job. Important vibe check though: only the owner of a domain can remove it. If you’re not the owner, this is not your main character moment — you can’t just delete someone else’s domain. Periodt.

🎀 PARAMETERS 🎀

• IF EXISTS — Do not throw an error if the domain does not exist. A notice is issued in this case instead. Very chill, no dramatic exit 😌
• name — The name of an existing domain, and yes it can be optionally schema-qualified. So you can point at exactly the domain you mean, iykyk.
• CASCADE — Automatically drop objects that depend on the domain (such as table columns), and in turn all objects that depend on those objects (see Section 5.14). This is the “take the dependents down with it” option, so highkey be careful 💀
• RESTRICT — Refuse to drop the domain if any objects depend on it. This is the default, so if you don’t pick CASCADE, RESTRICT is already the vibe.

🌸 EXAMPLES 🌸

To remove the domain box:

DROP DOMAIN box;

That’s it. That’s the example. Slay ✨

⭐ COMPATIBILITY ⭐

This command conforms to the SQL standard, bestie — except for the IF EXISTS option, which is a PostgreSQL extension. So that little safety net is very PostgreSQL, not standard SQL. Iykyk 🫶

👑 SEE ALSO 👑

• CREATE DOMAIN (CREATE_DOMAIN(7))
• ALTER DOMAIN (ALTER_DOMAIN(7))

---

okay that’s the whole page, bestie! This was PostgreSQL 13.23, dated 2025, and the page is DROP DOMAIN(7). Mwah 💖✨