MySQL Drop Database

We can delete an existing database in MySQL using the Drop database statement.

Drop a database in MySQL using command-line

show databases;

To see all the databases available.

drop database <database-name>;

For example:

drop database ccapp;

If a database does not exist and we try to drop it, MySQL throws an error shown below,

drop database somedb;

To avoid this error, we can use the syntax: This command is used to check the database first if it exists then delete the database otherwise it will throw a warning if the database doesn't exist.

drop database if exists <database-name>;

 drop database if exists somedb;

show databases;

drop database <database-name>;

drop database somedb2;

drop database practicedb;

drop database if exists <database-name>;

drop database if exists practicedb;