Drop Table

Now we will remove the table and get back to an empty database. First, let’s run:

SHOW TABLES

This will present all the tables in the database:

Now, perform the following SQL DROP command:

DROP TABLE employees

And don’t forget to also drop the workers table”

DROP TABLE workers

And then:

SHOW TABLES

And indeed, there are no tables in the database.