2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_rule.sgml,v 1.20 2003-11-29 19:51:38 pgsql Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-DROPRULE">
8
<refentrytitle id="SQL-DROPRULE-TITLE">DROP RULE</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP RULE</refname>
14
<refpurpose>remove a rewrite rule</refpurpose>
17
<indexterm zone="sql-droprule">
18
<primary>DROP RULE</primary>
23
DROP RULE <replaceable class="PARAMETER">name</replaceable> ON <replaceable class="PARAMETER">relation</replaceable> [ CASCADE | RESTRICT ]
28
<title>Description</title>
31
<command>DROP RULE</command> drops a rewrite rule.
36
<title>Parameters</title>
40
<term><replaceable class="parameter">name</replaceable></term>
43
The name of the rule to drop.
49
<term><replaceable class="parameter">relation</replaceable></term>
52
The name (optionally schema-qualified) of the table or view that
59
<term><literal>CASCADE</literal></term>
62
Automatically drop objects that depend on the rule.
68
<term><literal>RESTRICT</literal></term>
71
Refuse to drop the rule if any objects depend on it. This is
80
<title>Examples</title>
83
To drop the rewrite rule <literal>newrule</literal>:
86
DROP RULE newrule ON mytable;
92
<title>Compatibility</title>
95
There is no <command>DROP RULE</command> statement in the SQL standard.
100
<title>See Also</title>
102
<simplelist type="inline">
103
<member><xref linkend="sql-createrule" endterm="sql-createrule-title"></member>
109
<!-- Keep this comment at the end of the file
114
sgml-minimize-attributes:nil
115
sgml-always-quote-attributes:t
118
sgml-parent-document:nil
119
sgml-default-dtd-file:"../reference.ced"
120
sgml-exposed-tags:nil
121
sgml-local-catalogs:"/usr/lib/sgml/catalog"
122
sgml-local-ecat-files:nil