The DROP DATABASE statementdrops all tables in the database and deletes the database permanently. Therefore, you should be very careful when using this statement. DROP DATABASE [IF EXISTS] database_name; In this statement, you specify the name of the databasewhich you want to delete.