Database:
A database is an organized collection of data, generally stored and accessed electronically from a computer system.
Where databases are more complex they are often developed using formal design and modeling techniques.
What is DROP Database?
Drop database command are used to delete the particular database in MySql
To remove/delete/drop any existing database:
Syntax:
DROP DATABASE database_name;
Firstly check how many database we have:
SHOW DATABASE;
| Database |
|---|
| employee |
| student |
| library |
| shopping |
-In this program, we have a four type of database 'employee','student','library' and 'shopping'
Now we have to delete the library database:
DROP DATABASE library;
Now again check it work correctly or not:
SHOW DATABASE;
| Database |
|---|
| employee |
| student |
| shopping |
-In this query, you can see in output that there is no more library database exist.