<REFENTRY ID="SQL-DROPDATABASE"> <REFMETA> <REFENTRYTITLE> DROP DATABASE </REFENTRYTITLE> <REFMISCINFO>SQL - Language Statements</REFMISCINFO> </REFMETA> <REFNAMEDIV> <REFNAME> DROP DATABASE </REFNAME> <REFPURPOSE> Destroys an existing database </REFPURPOSE> <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> </TERM> <LISTITEM> <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> </LISTITEM> </VARLISTENTRY> </VARIABLELIST> </REFSECT2> <REFSECT2 ID="R2-SQL-DROPDATABASE-2"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> Outputs </TITLE> <PARA> </PARA> <VARIABLELIST> <VARLISTENTRY> <TERM> </TERM> <LISTITEM> <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> </variablelist> </LISTITEM> </VARLISTENTRY> </VARIABLELIST> </REFSECT2> </REFSYNOPSISDIV> <REFSECT1 ID="R1-SQL-DROPDATABASE-1"> <REFSECT1INFO> <DATE>1998-04-15</DATE> </REFSECT1INFO> <TITLE> Description </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> Notes </TITLE> <PARA> <warning> <para> This query should NOT be executed interactively. The <command>destroydb</command> script should be used instead. </para> </warning> <comment>Some explanation would be desirable here!</comment> </PARA> <para> DROP DATABASE statement is a PostgreSQL language extension. </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> Compatibility </TITLE> <PARA> </PARA> <REFSECT2 ID="R2-SQL-DROPDATABASE-4"> <REFSECT2INFO> <DATE>1998-04-15</DATE> </REFSECT2INFO> <TITLE> SQL92 </TITLE> <PARA> There is no DROP DATABASE statement in SQL92. </PARA> </refsect2> </refsect1> </REFENTRY> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../reference.ced" sgml-exposed-tags:nil sgml-local-catalogs:"/usr/lib/sgml/catalog" sgml-local-ecat-files:nil End: -->