Verify DROP DATABASE Statement
After the database has been deleted/dropped successfully we will now verify that whether the database exist in the system or not. So, we will once again use the SHOW DATABASES command and verify that the w3wiki database has been deleted or not.
Query
SHOW DATABASES;
Output
SQL DROP DATABASE
SQL DROP DATABASE statement deletes an existing database from the system, and once deleted, users can not retrieve that database.
The DROP DATABASE command in SQL deletes the database along with its data, like tables, views, indexes, constraints, and properties like permissions and schemas.