Drop database from mysql

The drop database command is used when you no longer need one of the SQL databases on your server. It will remove it permanently.

Query Syntax:

drop database databasename; //mysql

Examples: If the database to be dropped is called “customer_profile”, run the following query to delete the entire database. This will remove the database ‘customer_profile’ from the MySQL server. This is irrecoverable and there is no prompting to see if you really do want to drop the database.

drop database customer_profile;