DROP RULE SQL - Language Statements DROP RULE Removes an existing rule from the database 1998-04-15 DROP RULE name 1998-04-15 name The name of an existing rule to drop. 1998-04-15 DROP Message returned if successfully. ERROR: RewriteGetRuleEventRel: rule "name" not found This message occurs if the specified rule does not exist. 1998-04-15 DROP RULE drops a rule from the specified PostgreSQL rule system. PostgreSQL will immediately cease enforcing it and will purge its definition from the system catalogs. 1998-04-15 The DROP RULE statement is a PostgreSQL language extension. Refer to the CREATE RULE statement for information on how to create rules. 1998-04-15 Once a rule is dropped, access to historical information the rule has written may disappear. To drop the rewrite rule newrule: DROP RULE newrule 1998-04-15 There is no DROP RULE statement in SQL92.