DROP DATABASE
In MySQL, the DROP database command is used to drop or delete a MySQL database.
Syntax:
DROP DATABASE name;
Parameters:
name: It is used to specify the name of the database to be removed. The database name, table name, and table fields’ names in MySQL are case-sensitive.
Example:
DROP DATABASE stores;
Explanation:
The database named ‘stores’ will be deleted. You can verify it using the below query.
SHOW DATABASES;
The names of all the currently available databases after the removal will be displayed.