Name
DROP RULE
-- Removes existing rules from the database
Synopsis
Inputs
- name
The name of an existing rule to drop.
Outputs
- DROP
Message returned if successful.
- ERROR: Rule or view "name" not found
This message occurs if the specified rule does not exist.
Description
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.
Notes
Refer to CREATE RULE for
information on how to create rules.
Once a rule is dropped, access to historical information
that the rule has written may disappear.
Usage
To drop the rewrite rule newrule:
Compatibility
SQL92
There is no DROP RULE statement in SQL92.