Drop Database

The drop database command is used to remove your database from instant database directory. It will delete all its objects, table, spaces, containers and associated files.

Syntax:

Here, db_name specifies the name of the database you want to delete.

Example:

Let's delete the database name "XYZ2" from the instance.

Use the following command:

Output:

You can see the database XYZ2 is deleted now by using the following command:

Output: