diff options
Diffstat (limited to 'doc/src/sgml/ref/drop_database.sgml')
| -rw-r--r-- | doc/src/sgml/ref/drop_database.sgml | 232 |
1 files changed, 115 insertions, 117 deletions
diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index a2465550d8..d53d83efe6 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -1,161 +1,159 @@ -<REFENTRY ID="SQL-DROPDATABASE"> - <REFMETA> - <REFENTRYTITLE> +<refentry id="SQL-DROPDATABASE"> + <refmeta> + <refentrytitle> DROP DATABASE - </REFENTRYTITLE> - <REFMISCINFO>SQL - Language Statements</REFMISCINFO> - </REFMETA> - <REFNAMEDIV> - <REFNAME> + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> DROP DATABASE - </REFNAME> - <REFPURPOSE> + </refname> + <refpurpose> Destroys an existing database - </REFPURPOSE> + </refpurpose> </refnamediv> - <REFSYNOPSISDIV> - <REFSYNOPSISDIVINFO> - <DATE>1998-04-15</DATE> - </REFSYNOPSISDIVINFO> - <SYNOPSIS> -DROP DATABASE <REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE> - </SYNOPSIS> - - <REFSECT2 ID="R2-SQL-DROPDATABASE-1"> - <REFSECT2INFO> - <DATE>1998-04-15</DATE> - </REFSECT2INFO> - <TITLE> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-04-15</date> + </refsynopsisdivinfo> + <synopsis> +DROP DATABASE <replaceable class="PARAMETER">name</replaceable> + </synopsis> + + <refsect2 id="R2-SQL-DROPDATABASE-1"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Inputs - </TITLE> - <PARA> - </PARA> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <ReturnValue><REPLACEABLE CLASS="PARAMETER">name</REPLACEABLE></ReturnValue> - </TERM> - <LISTITEM> - <PARA> - The name of an existing database to remove. - </PARA> - </LISTITEM> - </VARLISTENTRY> - </variablelist> - </REFSECT2> - - <REFSECT2 ID="R2-SQL-DROPDATABASE-2"> - <REFSECT2INFO> - <DATE>1998-04-15</DATE> - </REFSECT2INFO> - <TITLE> + </title> + <para> + <variablelist> + <varlistentry> + <term><replaceable class="PARAMETER">name</replaceable></term> + <listitem> + <para> + The name of an existing database to remove. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + + <refsect2 id="R2-SQL-DROPDATABASE-2"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Outputs - </TITLE> - <PARA> + </title> + <para> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <ReturnValue>DESTROYDB</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - This message is returned if the command is successful. - </PARA> - </LISTITEM> - </VARLISTENTRY> - <VARLISTENTRY> - <TERM> - <ReturnValue>WARN: destroydb: database "<replaceable class="parameter">name</replaceable>" does not exist.</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - This message occurs if the specified database does not exist. - </PARA> - </LISTITEM> - </VARLISTENTRY> - <VARLISTENTRY> - <TERM> - <ReturnValue>ERROR: destroydb cannot be executed on an open database</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - This message occurs if the specified database does not exist. + <variablelist> + <varlistentry> + <term><computeroutput> +DESTROYDB + </computeroutput></term> + <listitem> + <para> + This message is returned if the command is successful. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term><computeroutput> +WARN: destroydb: database "<replaceable class="parameter">name</replaceable>" does not exist. + </computeroutput></term> + <listitem> + <para> + This message occurs if the specified database does not exist. </para> </listitem> </varlistentry> - </VARIABLELIST> + <varlistentry> + <term><computeroutput> + ERROR: destroydb cannot be executed on an open database + </computeroutput></term> + <listitem> + <para> + This message occurs if the specified database does not exist. + </para> + </listitem> + </varlistentry> + </variablelist> </para> - </REFSECT2> - </REFSYNOPSISDIV> + </refsect2> + </refsynopsisdiv> - <REFSECT1 ID="R1-SQL-DROPDATABASE-1"> - <REFSECT1INFO> - <DATE>1998-04-15</DATE> - </REFSECT1INFO> - <TITLE> + <refsect1 id="R1-SQL-DROPDATABASE-1"> + <refsect1info> + <date>1998-04-15</date> + </refsect1info> + <title> Description - </TITLE> - <PARA> + </title> + <para> <command>DROP DATABASE</command> removes the catalog entries for an existing database and deletes the directory containing the data. It can only be executed by the database administrator (See the <command>CREATE DATABASE</command> command for details). - </PARA> - - <REFSECT2 ID="R2-SQL-DROPDATABASE-3"> - <REFSECT2INFO> - <DATE>1998-04-15</DATE> - </REFSECT2INFO> - <TITLE> + </para> + + <refsect2 id="R2-SQL-DROPDATABASE-3"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> Notes - </TITLE> + </title> <para> - DROP DATABASE statement is a <productname>Postgres</productname> - language extension. + <command>DROP DATABASE</command> statement is a <productname>Postgres</productname> + language extension. <tip> <para> This query cannot be executed while connected to the target -database. It is usually preferable to use the - <command>destroydb</command> script instead. + database. It is usually preferable to use the + <command>destroydb</command> script instead. </para> </tip> - </para> + <para> Refer to the <command>CREATE DATABASE</command> statement for information on how to create a database. </para> </refsect2> - </REFSECT1> - - <REFSECT1 ID="R1-SQL-DROPDATABASE-3"> - <TITLE> + </refsect1> + + <refsect1 id="R1-SQL-DROPDATABASE-3"> + <title> Compatibility - </TITLE> - <PARA> - </PARA> + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-DROPDATABASE-4"> - <REFSECT2INFO> - <DATE>1998-04-15</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPDATABASE-4"> + <refsect2info> + <date>1998-04-15</date> + </refsect2info> + <title> SQL92 - </TITLE> - <PARA> - There is no <command>DROP DATABASE</command> in <acronym>SQL92</acronym>. - </PARA> + </title> + <para> + There is no <command>DROP DATABASE</command> in <acronym>SQL92</acronym>. + </para> </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 |