t
 Title: DROP RULE
 Author: The PostgreSQL Global Development Group
 Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
 Date: 2021
 Manual: PostgreSQL 10.19 Documentation
 Source: PostgreSQL 10.19
 Language: English

 "DROP RULE" "7" "2021" "PostgreSQL 10.19" "PostgreSQL 10.19 Documentation"
 -----------------------------------------------------------------
 * Define some portability stuff
 -----------------------------------------------------------------
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 http://bugs.debian.org/507673
 http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 -----------------------------------------------------------------
 * set default formatting
 -----------------------------------------------------------------
 disable hyphenation
 disable justification (adjust text to left margin only)
 -----------------------------------------------------------------
 * MAIN CONTENT STARTS HERE *
 -----------------------------------------------------------------
 "NAME"
DROP_RULE - remove a rewrite rule

 "SYNOPSIS"
DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]



 "DESCRIPTION"

DROP RULE
drops a rewrite rule.

 "PARAMETERS"

IF EXISTS


Do not throw an error if the rule does not exist. A notice is issued in this case.




name


The name of the rule to drop.




table_name


The name (optionally schema-qualified) of the table or view that the rule applies to.




CASCADE


Automatically drop objects that depend on the rule, and in turn all objects that depend on those objects (see
Section 5.13).




RESTRICT


Refuse to drop the rule if any objects depend on it. This is the default.



 "EXAMPLES"

To drop the rewrite rule
newrule:


.\}

DROP RULE newrule ON mytable;




.\}

 "COMPATIBILITY"

DROP RULE
is a
PostgreSQL
language extension, as is the entire query rewrite system.

 "SEE ALSO"
CREATE RULE (CREATE_RULE(7)), ALTER RULE (ALTER_RULE(7))