DROP RULE - Removes existing rules from the database


SYNOPSIS

       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.


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.

       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.


Man(1) output converted with man2html