DROP RULE PostgreSQL User's GuidePrevNextDROP RULEName DROP RULE — Removes an existing rule from the database DROP RULE name Inputs name The name of an existing rule to drop. Outputs DROP Message returned if successfully. ERROR: RewriteGetRuleEventRel: rule "name" not found This message occurs if the specified rule does not exist. Description DROP RULE drops a rule from the specified Postgres rule system. Postgres will immediately cease enforcing it and will purge its definition from the system catalogs. Notes The DROP RULE statement is a Postgres language extension. Refer to CREATE RULE for information on how to create rules. Bugs Once a rule is dropped, access to historical information the rule has written may disappear. Usage To drop the rewrite rule newrule: DROP RULE newrule Compatibility SQL92 There is no DROP RULE in SQL92. PrevHomeNextDROP OPERATORUpDROP SEQUENCE