DROP RULE SQL - Language Statements DROP RULE remove a rewrite rule 1998-09-22 DROP RULE name ON relation 1998-09-22 name The name of an existing rule to drop. relation The name (optionally schema-qualified) of the relation the rule applies to. 1998-09-22 DROP RULE Message returned if successful. ERROR: Rule "name" not found This message occurs if the specified rule does not exist. 1998-09-22 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-09-22 The DROP RULE statement is a PostgreSQL language extension. Refer to CREATE RULE for information on how to create rules. To drop the rewrite rule newrule: DROP RULE newrule ON mytable; 1998-09-22 There is no DROP RULE in SQL92.