Pegasus InfoCorp: Web site design and web software development company

DROP_DATABASE (l)

Destroys an existing database

SYNOPSIS

    DROP DATABASE name
    

    name

      The name of an existing database to remove.

    DESTROYDB

      This message is returned if the command is successful.

    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).

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

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

COMPATIBILITY

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