SQL > Data Definition Language (DDL) > Drop Database StatementSometimes we may decide that we need to delete of an entire database in the RDBMS. In fact, if we cannot do so, we would be faced with a maintenance nightmare. Fortunately, SQL allows us to do it, as we can use the DROP DATABASE command. The syntax for DROP DATABASE is,

DROP DATABASE "database_name";
So, if we wanted to drop the HOLIDAYS database that we created in the CREATE DATABASEsection, we simply type

DROP DATABASE HOLIDAYS;
Please note that any table that is still in the database will also disappear once the database is dropped.