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.
Here, db_name specifies the name of the database you want to delete.
Let’s delete the database name “XYZ2” from the instance.
Use the following command:
You can see the database XYZ2 is deleted now by using the following command: