Removing a table from a database schema is easy. Just use a DROP TABLE
<tablename> statement. You erase all data from the table, as well as the metadata that defines the table in the data dictionary. It’s almost as if the table never existed. You can also use the DROP statement to get rid of anything that was created by a CREATE statement.

The DROP TABLE statement is used to drop an existing table in a database.

           DROP TABLE table_name;