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’ name 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.