OrientDB - Drop Database

Similar to RDBMS, OrientDB provides the feature to drop a database. Drop database refers to removing a database completely.

The following statement is the basic syntax of the Drop database command.

DROP DATABASE [<database-name> <server-username> <server-user-password>]

Following are the details about the options in the above syntax.

<database-name> − Database name you want to drop.

<server-username> − Username of the database who has the privilege to drop a database.

<server-user-password> − Password of the particular user.

Example

There are two ways to drop a database, one is drop a currently open database and second is drop a particular database by providing the particular name.

In this example, we will use the same database named ‘demo’ that we created in an earlier chapter. You can use the following command to drop a database demo.

orientdb {db = demo}> DROP DATABASE

If this command is successfully executed, you will get the following output.

Database 'demo' deleted successfully

OR

You can use another command to drop a database as follows.

orientdb> DROP DATABASE PLOCAL:/opt/orientdb/databases/demo admin admin 

If this command is successfully executed, you will get the following output.

Database 'demo' deleted successfully