DROP_DATABASE(l)                                 DROP_DATABASE(l)

NAME
       DROP DATABASE - Destroys an existing database

SYNOPSIS
       DROP DATABASE name

   INPUTS
       name   The name of an existing database to remove.

   OUTPUTS
       DESTROYDB
              This message is returned if the command is success-
              ful.

       WARN: destroydb: database "name" does not exist.
              This message occurs if the specified database  does
              not exist.

       ERROR: destroydb cannot be executed on an open database
              This  message occurs if the specified database does
              not exist.

DESCRIPTION
       DROP DATABASE 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 CREATE DATABASE command for details).

   NOTES
       This  query cannot be executed while connected to the tar-
       get database. It is usually preferable to use destroydb(1)
       instead.

       Refer  to  createdb(1) and create_database(l) for informa-
       tion on how to create a database.

COMPATIBILITY
   SQL92
       DROP DATABASE statement is a Postgres language  extension;
       there is no such command in SQL92.

SQL - Language Statements 15 August 1999                        1