DROP DATABASE
Use the DROP DATABASE command to drop a database. It also removes catalog entries for the database and deletes the directory that contains the data. The DROP DATABASE command cannot be undone. You cannot issue this command while you are connected to the target database.
Syntax
Syntax for the DROP
DATABASE command:
DROP DATABASE <name>
Input
The DROP DATABASE command
takes the following input:
Input | Description |
---|---|
<name> | The name of the database to be dropped. |
Outputs
The DROP DATABASE
command has the following outputs:
Output | Description |
---|---|
DROP DATABASE | The command was successful. |
DROP DATABASE: cannot be executed on the currently open database | You cannot be connected to the database that you are about to remove. Connect to any other database, and run the command again. |
DROP DATABASE: may not be called in a transaction block | You must finish the transaction in progress before you can call the command. |
ERROR: Can't delete database - num object(s) depend on objects in it | The database contains objects such as user-defined functions,
user-defined aggregates, or stored procedures, which are dependencies
for objects that are defined in other databases. Use the SELECT
* FROM_v_depend query to identify the objects in other databases
that depend on objects in the database that you want to drop. You
must resolve all the dependencies by either dropping or altering those
objects before you can drop the database. |
ERROR: DROP DATABASE: Database "DB_NAME" has 269968 tables and/or sequences. Objects must be manually dropped until the number is less than 260000. | The database contains more than 260,000 objects. You must manually drop objects in the database until the object number is below 260,000. You can then use the DROP DATABASE command to drop the database. |
Privileges
You must be the admin user, the database owner, or your account must have the Delete privilege for the database or for the Database object class.
Usage
The following provides
sample usage:
- Drop the database
emp
:MYDB.SCH1(USER)=> DROP DATABASE emp;