DROP_RULE(7pg14)

💅 DROP_RULE — bestie, let's delete a rewrite rule ✨

okay so real talk, this is the PostgreSQL 14 manual page for DROP RULE, and it's honestly one of the more chill commands out there — it does exactly one thing and it does it slayfully. 🎀

---

🌸 SYNOPSIS 🌸

DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]

that's the whole vibe. no cap. look at it. gorgeous. ✨

---

🦋 DESCRIPTION 🦋

DROP RULE drops a rewrite rule. that's it. that's the entire description. lowkey iconic of it to be so concise, honestly. 💅

---

💖 PARAMETERS 💖

• IF EXISTS — bestie, do not throw an error if the rule doesn't exist. instead it just issues a notice and moves on with its life. very "no thoughts, head empty" of it, and we respect that. 🙈
• name — the name of the rule you're dropping. yes, you have to know it. no, it won't guess. 🎀
• table_name — the name of the table or view that the rule applies to. it can be schema-qualified if you're being fancy about it (the "optionally" is doing a lot of work there). ✨
• CASCADE — automatically drops objects that depend on the rule, and in turn all objects that depend on those objects (check Section 5.14 if you want the full lore). this is the "and everyone they brought to the party" option. 😭
• RESTRICT — refuses to drop the rule if any objects depend on it. this is the default, so if you're not specifying anything, congrats, you already picked RESTRICT. 🫶

---

🌈 EXAMPLES 🌈

say you wanna drop the rewrite rule newrule — here's the moment:

DROP RULE newrule ON mytable;

she ate. periodt. 🔥

---

⭐ COMPATIBILITY ⭐

DROP RULE is a PostgreSQL language extension — and honestly so is the entire query rewrite system, so like… the whole family is built different. iykyk. 💜

---

👑 SEE ALSO 👑

• CREATE RULE (CREATE_RULE(7))
• ALTER RULE (ALTER_RULE(7))

go make rules, go change rules, go delete rules — full circle, bestie. 🦋

---

ok so that's the whole page!! PostgreSQL 14.24, dated 2026, and the page is DROP RULE(7) in case you forgot where you were. mwah, go drop some rules responsibly 💋✨🎀