SQL DROP Database

SQL DROP DATABASE statement to drop the existing database.

Syntax

DROP DATABASE database_name;

Example

SQL> DROP DATABASE user_db;

Now you can again execute SHOW DATABASE statement. user_db database deleted.

SQL> SHOW DATABASES;

+---------------------+
| Database            |
+---------------------+
| information_schema  |
| scott               |
| demodb              |
+---------------------+ 
3 rows in set (0.00 sec)