Console - DROP DATABASE
Removes a database completely. If the database is open and a database name not given, it removes the current database.
Syntax
DROP DATABASE [<database-name> <server-username> <server-user-password>]
- <database-nameDefines the database you want to drop. By default it uses the current database, if it's open.
- <server-username>Defines the server user. This user must have the privileges to drop the database.
- <server-user-password>Defines the password for the server user.
NOTE: When you drop a database, it deletes the database and all records, caches and schema information it contains. Unless you have made backups, there is no way to restore the database after you drop it.
Examples
- Remove the current local database: - orientdb>- DROP DATABASE
- Remove the database - demoat localhost:- orientdb>- DROP DATABASE REMOTE:localhost/demo root root_password
You can create a new database using the
CREATE DATABASEcommand. To make changes to an existing database, use theALTER DATABASEcommand.For more information on other commands, see SQL and Console commands.