CodesJava

Easy learning with example program codes

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

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status