You may have found that you've created a table that you no longer require. You can use the DROP TABLE statement to remove the table from your database.
Let's look at an example that shows how to drop a table using the DROP TABLE statement.
DROP TABLE suppliers;
This DROP TABLE statement example would drop the table called suppliers. This would both remove the records associated with the suppliers table as well as its table definition.
Once you have dropped the table, you can recreate the suppliers table without getting an error that the table already exists.
Let's look at one more example where we prefix the table name with the database name.
DROP TABLE totn.contacts;
In this example, e have dropped a table called contacts that is in the totn database.
TIP: It is sometimes easier to drop a table and recreate it, instead of using the ALTER TABLE statement to change the table's definition.