MySQL DROP DATABASE Statement
The MySQL DROP DATABASE Statement
The DROP DATABASE statement is used to permanently delete an existing SQL database.
Note: Be careful before dropping a database! Dropping a database deletes the database and all its content (tables, views, stored procedures, and data)!
Syntax
DROP DATABASE databasename;
Tip: You need administrative privileges to drop a database.
DROP DATABASE Example
The following SQL statement drops the existing database "testDB":
Example
DROP DATABASE testDB;
Tip: Once a database is dropped, you can check that it is removed from the list of databases
with the: SHOW DATABASES; command.
