Drop Database in MySQL

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.

Please follow and like us:
Content Protection by DMCA.com