DROP DATABASE is used to delete the database in our Database Management System. For example,
DROP DATABASE my_db;
Here, the SQL command will delete a database named my_db.
Also make sure you have admin or DROP permission to run this command.
Note: When we delete a database, all tables and records within a database are also deleted.
List all Databases
To verify the drop database, we can run the following command to list the available databases.
Here, the SQL command lists all the available databases in the DBMS.