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