GNU/Linux |
RedHat 6.2(Zoot) |
|
![]() |
drop_database(l) |
![]() |
DROP DATABASE − Destroys an existing database
DROP DATABASE name
INPUTS
name |
The name of an existing database to remove. |
OUTPUTS
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.
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 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.
SQL92
DROP DATABASE statement is a Postgres language
extension; there is no such command in SQL92.
![]() |
drop_database(l) | ![]() |