1The DROP DATABASE statement drops all tables in the database and deletes the database permanently. Therefore, you should be very careful when using this statement.
2
3The following shows the syntax of the DROP DATABASE statement:
4
5DROP DATABASE [IF EXISTS] database_name;
6
7
8
9In MySQL, the schema is the synonym for the database, therefore, you can use them interchangeably:
10
11DROP SCHEMA [IF EXISTS] database_name;