MySQL Clients: Dropping DB and table

This entry is part 7 of 8 in the series MySQL Clients

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



Series Navigation<< MySQL Clients: Setting connection to DB
MySQL Clients: Creating DB and table >>

Leave a comment

Leave a Reply