DROP RULE
  
  SQL - Language Statements
 
 
  
   DROP RULE
  
  
   remove a rewrite rule
  
 
 
  
   1998-09-22
  
  
DROP RULE name [, ...]
  
  
  
   
    1998-09-22
   
   
    Inputs
   
   
    
     
      name
      
       
	The name of an existing rule to drop.
       
      
     
    
   
  
  
   
    1998-09-22
   
   
    Outputs
   
   
    
     
      
DROP
       
      
       
	Message returned if successful.
       
      
     
     
      
ERROR:  Rule or view "name" not found
       
      
       
	This message occurs if the specified rule does not exist.
       
      
     
    
   
  
 
 
  
   1998-09-22
  
  
   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.
  
  
   
    1998-09-22
   
   
    Notes
   
   
    The DROP RULE statement is a
    PostgreSQL
    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
  
  
   
    1998-09-22
   
   
    SQL92
   
   
    There is no DROP RULE in SQL92.