DROP_RULE(l)                                         DROP_RULE(l)

NAME
       DROP RULE - Removes an existing rule from the database

SYNOPSIS
       DROP RULE name

   INPUTS
       name   The name of an existing rule to drop.

   OUTPUTS
       DROP   Message returned if successfully.

       ERROR: RewriteGetRuleEventRel: rule "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.

SQL - Language Statements 15 August 1999                        1