The SQL DROP DATABASE statement is the SQL command that removes an existing database. A database is the outer container for other SQL objects: tables, columns, views, indexes, etc.
Anytime you want to remove an existing database. For example, you may want to eliminate an a database called CUSTOMER_DB_DEV that is no longer required for database development.
The SQL DROP DATABASE statement is used as follows.
SQL DROP DATABASE Statement Syntax
DROP DATABASE <database_name>
SQL DROP DATABASE Statement Example
The following example drops an existing database named CUSTOMER_DB_DEV.
DROP DATABASE customer_db_dev