diff options
Diffstat (limited to 'doc/src/sgml/ref/drop_view.sgml')
| -rw-r--r-- | doc/src/sgml/ref/drop_view.sgml | 292 |
1 files changed, 143 insertions, 149 deletions
diff --git a/doc/src/sgml/ref/drop_view.sgml b/doc/src/sgml/ref/drop_view.sgml index 98449d0eef..32e5c34e20 100644 --- a/doc/src/sgml/ref/drop_view.sgml +++ b/doc/src/sgml/ref/drop_view.sgml @@ -1,76 +1,74 @@ -<REFENTRY ID="SQL-DROPVIEW"> - <REFMETA> - <REFENTRYTITLE> +<refentry id="SQL-DROPVIEW"> + <refmeta> + <refentrytitle> DROP VIEW - </REFENTRYTITLE> - <REFMISCINFO>SQL - Language Statements</REFMISCINFO> - </REFMETA> - <REFNAMEDIV> - <REFNAME> + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> DROP VIEW - </REFNAME> - <REFPURPOSE> + </refname> + <refpurpose> Removes an existing view from a database - </REFPURPOSE> + </refpurpose> </refnamediv> - <REFSYNOPSISDIV> - <REFSYNOPSISDIVINFO> - <DATE>1998-09-22</DATE> - </REFSYNOPSISDIVINFO> - <SYNOPSIS> -DROP VIEW <REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE> - </SYNOPSIS> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-22</date> + </refsynopsisdivinfo> + <synopsis> +DROP VIEW <replaceable class="PARAMETER">name</replaceable> + </synopsis> - <REFSECT2 ID="R2-SQL-DROPVIEW-1"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPVIEW-1"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Inputs - </TITLE> - <PARA> - </PARA> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of an existing view. - </PARA> - </LISTITEM> - </VARLISTENTRY> - </variablelist> - </REFSECT2> - - <REFSECT2 ID="R2-SQL-DROPVIEW-2"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + </title> + <para> + + <variablelist> + <varlistentry> + <term><replaceable class="PARAMETER">name</replaceable></term> + <listitem> + <para> + The name of an existing view. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + + <refsect2 id="R2-SQL-DROPVIEW-2"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Outputs - </TITLE> - <PARA> + </title> + <para> -<VARIABLELIST> -<VARLISTENTRY> -<TERM> -<ReturnValue>DROP</ReturnValue> -</TERM> -<LISTITEM> - <PARA> - The message returned if the command is successful. + <variablelist> + <varlistentry> + <term><computeroutput> +DROP + </computeroutput></term> + <listitem> + <para> + The message returned if the command is successful. </para> </listitem> </varlistentry> - <VARLISTENTRY> - <TERM> - <ReturnValue> - ERROR: RewriteGetRuleEventRel: rule "_RET<REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE>" not found</ReturnValue> - </TERM> - <LISTITEM> - <PARA> + <varlistentry> + <term><computeroutput> +ERROR: RewriteGetRuleEventRel: rule "_RET<replaceable class="PARAMETER">name</replaceable>" not found + </computeroutput></term> + <listitem> + <para> This message occurs if the specified view does not exist in the database. </para> @@ -78,99 +76,99 @@ DROP VIEW <REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE> </varlistentry> </variablelist> </para> - </REFSECT2> - </REFSYNOPSISDIV> - - <REFSECT1 ID="R1-SQL-DROPVIEW-1"> - <REFSECT1INFO> - <DATE>1998-09-22</DATE> - </REFSECT1INFO> - <TITLE> + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-DROPVIEW-1"> + <refsect1info> + <date>1998-09-22</date> + </refsect1info> + <title> Description - </TITLE> - <PARA> + </title> + <para> <command>DROP VIEW</command> drops an existing view from the database. To execute this command you must be the owner of the view. - </PARA> + </para> - <REFSECT2 ID="R2-SQL-DROPVIEW-3"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPVIEW-3"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Notes - </TITLE> - <PARA> + </title> + <para> The <productname>Postgres</productname> - <command>DROP TABLE</command> statement also drops views. - </PARA> -<PARA> + <command>DROP TABLE</command> statement also drops views. + </para> + <para> Refer to <command>CREATE VIEW</command> - for information on how to create views. - </PARA> - </REFSECT2> + for information on how to create views. + </para> + </refsect2> </refsect1> - - <REFSECT1 ID="R1-SQL-DROPVIEW-2"> - <TITLE> + + <refsect1 id="R1-SQL-DROPVIEW-2"> + <title> Usage - </TITLE> - <PARA> + </title> + <para> This command will remove the view called <literal>kinds</literal>: - </PARA> - <ProgramListing> + </para> + <programlisting> DROP VIEW kinds; - </ProgramListing> - </REFSECT1> + </programlisting> + </refsect1> - <REFSECT1 ID="R1-SQL-DROPVIEW-3"> - <TITLE> + <refsect1 id="R1-SQL-DROPVIEW-3"> + <title> Compatibility - </TITLE> - <PARA> - </PARA> + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-DROPVIEW-4"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPVIEW-4"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> SQL92 - </TITLE> - <PARA> + </title> + <para> <acronym>SQL92</acronym> specifies some additional capabilities for <command>DROP VIEW</command>: - </PARA> - <synopsis> + <synopsis> DROP VIEW <replaceable class="parameter">view</replaceable> { RESTRICT | CASCADE } - </synopsis> + </synopsis> + </para> - <REFSECT3 ID="R3-SQL-DROPVIEW-1"> - <REFSECT3INFO> - <DATE>1998-09-22</DATE> - </REFSECT3INFO> - <TITLE> - Inputs - </TITLE> - <PARA> - <variablelist> - <varlistentry> - <term>RESTRICT</term> - <listitem> - <para> - Ensures that only a view with no dependent views or - integrity constraints can be destroyed. - </para> - </listitem> - </varlistentry> - <varlistentry> - <term>CASCADE</term> - <listitem> - <para> - Any referencing views and integrity constraints - will be dropped as well. + <refsect3 id="R3-SQL-DROPVIEW-1"> + <refsect3info> + <date>1998-09-22</date> + </refsect3info> + <title> + Inputs + </title> + <para> + <variablelist> + <varlistentry> + <term>RESTRICT</term> + <listitem> + <para> + Ensures that only a view with no dependent views or + integrity constraints can be destroyed. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term>CASCADE</term> + <listitem> + <para> + Any referencing views and integrity constraints + will be dropped as well. </para> </listitem> </varlistentry> @@ -178,31 +176,27 @@ DROP VIEW <replaceable class="parameter">view</replaceable> { RESTRICT | CASCADE </para> </refsect3> - <REFSECT3 ID="R3-SQL-DROPVIEW-2"> - <REFSECT3INFO> - <DATE>1998-09-22</DATE> - </REFSECT3INFO> - <TITLE> + <refsect3 id="R3-SQL-DROPVIEW-2"> + <refsect3info> + <date>1998-09-22</date> + </refsect3info> + <title> Notes - </TITLE> + </title> <para> - <tip> - <para> - At present, to remove a referenced view from a - <productname>Postgres</productname> database, - you must drop it explicitly. - </para> - </tip> + At present, to remove a referenced view from a + <productname>Postgres</productname> database, + you must drop it explicitly. </para> </refsect3> </refsect2> </refsect1> -</REFENTRY> +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml -sgml-omittag:t +sgml-omittag:nil sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t |