Red Hat Database: SQL Guide and Reference
PrevNext

DROP DATABASE

Name

DROP DATABASE  --  Removes an existing database

Synopsis

DROP DATABASE name

Inputs

name

The name of an existing database to remove.

Outputs

DROP DATABASE

This message is returned if the command is successful.

DROP DATABASE: cannot be executed on the currently open database

You cannot be connected to the database you are about to remove. Instead, connect to template1 or any other database and run this command again.

DROP DATABASE: may not be called in a transaction block

You must finish the transaction in progress before you can call this command.

Description

DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data. It can be executed only by the database owner.

Notes

This command cannot be executed while connected to the target database. It might be more convenient to use the shell script dropdb, which is a wrapper around this command, instead. For more information, refer to the Red Hat Database Administrator and User's Guide

Refer to CREATE DATABASE for information on how to create a database.

Usage

To create a new database: 
   CREATE DATABASE redhatdb;

Work on database. To remove/drop a database: 
   DROP DATABASE redhatdb;

Compatibility

SQL92

There is no DROP DATABASE statement in SQL92.

PrevHomeNext
DROP AGGREGATEUpDROP FUNCTION