GNU/Linux |
CentOS 2.1AS(Slurm) |
|
![]() |
drop_rule(l) |
![]() |
DROP RULE − Removes existing rules from the database
DROP RULE name [, ...]
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.
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.
Once a rule is dropped, access to historical information the rule has written may disappear.
To drop the rewrite rule newrule:
DROP RULE newrule;
SQL92
There is no DROP RULE in SQL92.
![]() |
drop_rule(l) | ![]() |