DROP_DOMAIN(7pg16)

💖 NAME 💖

okay so this is DROP_DOMAIN — the remove-a-domain page from the 7pg16 manual. literally: remove a domain 🎀

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

DROP DOMAIN removes a domain. Only the owner of a domain can remove it. that's the rule, bestie — if you're not the owner, no domain-dropping for you 🙈

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the domain does not exist. A notice is issued in this case. so it's like “she's not here, but we're not gonna make it a whole thing” 💅
• name — the name (optionally schema-qualified) of an existing domain. yes, schema-qualified is allowed, 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 full-send option 😭
• RESTRICT — refuse to drop the domain if any objects depend on it. This is the default. cautious queen behavior 👑

🌈 EXAMPLES 🌈

To remove the domain box:

DROP DOMAIN box;

💜 COMPATIBILITY 💜

This command conforms to the SQL standard, except for the IF EXISTS option, which is a PostgreSQL extension. standards girlie with one lil PostgreSQL extra ✨

🫶 SEE ALSO 🫶

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

okay that's a wrap, bestie. this page is from PostgreSQL 16.15, dated 2026, and it's literally the DROP DOMAIN(7) page. catch u later — go forth and drop domains responsibly 💖✨