DROP DATABASE command is used to drop a database in MariaDB. Be very careful with this statement! To use a DROP DATABASE, you need to DROP privileges on the database. DROP SCHEMA is a synonym for DROP DATABASE
NOTE : When a database is dropped, user privileges on the database are not automatically
Syntax :
DROP DATABASE Database_name;
IF EXISTS statement :
Use IF EXISTS to prevent an error from occurring for the database that does not exist. A note is generated for each non-existent database when using IF EXISTS statement.
Example :
Output :
Query OK, 0 rows affected (0.39 sec)
DROP DATABASE student; ​
Output :
ERROR (1008): can't drop database; database doesn't exists [\]w: show warning enabled
DROP DATABASE IF EXISTS student;
Output :
Query OK, 0 rows affected, 1 warning (0.00 sec)
Note (code 1008) : can't drop database 'student'; database doesn't exists