DROP DATABASE statement

ByMisterFoxOnline

Jun 9, 2024 #DROP DATABASE, #MySQL tutorial, #MySQL Workbench tutorial

Equally as simple as the CREATE DATABASE statement, the DROP DATABASE statement will destroy an entire database. This tutorial uses MySQL Workbench.

In this tutorial:

Syntax
Example

Required knowledge:

CREATE DATABASE statement

Syntax

DROP DATABASE `databasename`;

Example

Continuing from the CREATE DATABASE statement tutorial, we will now DROP the database in MySQL Workbench using the following SQL:

DROP DATABASE `dbtest`;

Select the database, dbtest
Select the Query window
Type the query DROP DATABASE dbtest;
Click the Execute button
The Output panel with the results of the statement
The dbtest database has been dropped

References:

W3Schools.com (no date) MySQL DROP DATABASE Statement. Available at: https://www.w3schools.com/mysql/mysql_drop_db.asp (Accessed: 9 June 2024).

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.