drop_database.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:4k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-DROPDATABASE">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    DROP DATABASE
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    DROP DATABASE
  11.   </refname>
  12.   <refpurpose>
  13.    Destroys an existing database
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-04-15</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. DROP DATABASE <replaceable class="PARAMETER">name</replaceable>
  22.   </synopsis>
  23.   <refsect2 id="R2-SQL-DROPDATABASE-1">
  24.    <refsect2info>
  25.     <date>1998-04-15</date>
  26.    </refsect2info>
  27.    <title>
  28.     Inputs
  29.    </title>
  30.    <para>
  31.     <variablelist>
  32.      <varlistentry>
  33.       <term><replaceable class="PARAMETER">name</replaceable></term>
  34.       <listitem>
  35.        <para>
  36. The name of an existing database to remove.
  37.        </para>
  38.       </listitem>
  39.      </varlistentry>
  40.     </variablelist>
  41.    </para>
  42.   </refsect2>
  43.   <refsect2 id="R2-SQL-DROPDATABASE-2">
  44.    <refsect2info>
  45.     <date>1998-04-15</date>
  46.    </refsect2info>
  47.    <title>
  48.     Outputs
  49.    </title>
  50.    <para>
  51.     <variablelist>
  52.      <varlistentry>
  53.       <term><computeroutput>
  54. DESTROYDB
  55.        </computeroutput></term>
  56.       <listitem>
  57.        <para>
  58. This message is returned if the command is successful.
  59.        </para>
  60.       </listitem>
  61.      </varlistentry>
  62.      <varlistentry>
  63.       <term><computeroutput>
  64. WARN: destroydb: database "<replaceable class="parameter">name</replaceable>" does not exist.
  65.        </computeroutput></term>
  66.       <listitem>
  67.        <para>
  68. This message occurs if the specified database does not exist.
  69.        </para>
  70.       </listitem>
  71.      </varlistentry>
  72.      <varlistentry>
  73.       <term><computeroutput>
  74. ERROR:  destroydb cannot be executed on an open database
  75.        </computeroutput></term>
  76.       <listitem>
  77.        <para>
  78. This message occurs if the specified database does not exist.
  79.        </para>
  80.       </listitem>
  81.      </varlistentry>
  82.     </variablelist>
  83.    </para>
  84.   </refsect2>
  85.  </refsynopsisdiv>
  86.  
  87.  <refsect1 id="R1-SQL-DROPDATABASE-1">
  88.   <refsect1info>
  89.    <date>1998-04-15</date>
  90.   </refsect1info>
  91.   <title>
  92.    Description
  93.   </title>
  94.   <para>
  95.    <command>DROP DATABASE</command> removes the catalog entries for an existing
  96.    database and deletes the directory containing the data.
  97.    It can only be executed by the database administrator
  98.    (See the <command>CREATE DATABASE</command> command for details).
  99.   </para>
  100.   <refsect2 id="R2-SQL-DROPDATABASE-3">
  101.    <refsect2info>
  102.     <date>1998-04-15</date>
  103.    </refsect2info>
  104.    <title>
  105.     Notes
  106.    </title>
  107.    <para>
  108.     <command>DROP DATABASE</command> statement is a <productname>Postgres</productname>
  109.     language extension.
  110.     <tip>
  111.      <para>
  112.       This query cannot be executed while connected to the target
  113.       database. It is usually preferable to use the
  114.       <command>destroydb</command> script instead.
  115.      </para>
  116.     </tip>
  117.    </para>
  118.    <para>
  119.     Refer to the <command>CREATE DATABASE</command> statement for
  120.     information on how to create a database.
  121.    </para>
  122.   </refsect2>
  123.  </refsect1>
  124.  <refsect1 id="R1-SQL-DROPDATABASE-3">
  125.   <title>
  126.    Compatibility
  127.   </title>
  128.   <para>
  129.   </para>
  130.   <refsect2 id="R2-SQL-DROPDATABASE-4">
  131.    <refsect2info>
  132.     <date>1998-04-15</date>
  133.    </refsect2info>
  134.    <title>
  135.     SQL92
  136.    </title>
  137.    <para>
  138.     There is no <command>DROP DATABASE</command> in <acronym>SQL92</acronym>.
  139.    </para>
  140.   </refsect2>
  141.  </refsect1>
  142. </refentry>
  143. <!-- Keep this comment at the end of the file
  144. Local variables:
  145. mode: sgml
  146. sgml-omittag:nil
  147. sgml-shorttag:t
  148. sgml-minimize-attributes:nil
  149. sgml-always-quote-attributes:t
  150. sgml-indent-step:1
  151. sgml-indent-data:t
  152. sgml-parent-document:nil
  153. sgml-default-dtd-file:"../reference.ced"
  154. sgml-exposed-tags:nil
  155. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  156. sgml-local-ecat-files:nil
  157. End:
  158. -->