DROP_RULE(7pg17)

💖 NAME 💖

okay so bestie, welcome to DROP_RULE(7pg17) — aka the DROP RULE(7) manual page — and it’s literally all about how to remove a rewrite rule. That’s the main character energy here. ✨

🦋 SYNOPSIS 🦋

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

🌸 DESCRIPTION 🌸

DROP RULE drops a rewrite rule. Simple, iconic, done. 💅

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the rule does not exist. A notice is issued in this case. 🫶
• name — the name of the rule to drop.
• table_name — the name (optionally schema-qualified) of the table or view that the rule applies to.
• CASCADE — automatically drop objects that depend on the rule, and in turn all objects that depend on those objects (see Section 5.15). 🔥
• RESTRICT — refuse to drop the rule if any objects depend on it. This is the default. 🛑

🌈 EXAMPLES 🌈

To drop the rewrite rule newrule:

DROP RULE newrule ON mytable;

⭐ COMPATIBILITY ⭐

DROP RULE is a PostgreSQL language extension, as is the entire query rewrite system. periodt. 💜

👑 SEE ALSO 👑

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

okay bye bestie — this was DROP_RULE(7pg17) / DROP RULE(7), pulled from PostgreSQL 17.11 Documentation, dated 2026. mwah 💋