Now that we know that the database allartist and a table known as artist have been created. Let’s drop them and recreate them.
Since there is a table known as artist that is attached to the database allartist, we would have to first drop table artist.
To drop the table, execute the command:
use allartist drop table artist
Next we drop the database using the command:
drop database allartist