You can use the DROP TABLE statement to delete the database tables that you no longer need. The DROP TABLE statement permanently erase all data from the table. The DROP TABLE removes one or more tables.
DROP TABLE persons;
Similarly, you can delete a database using the DROP DATABASE statement. The following command will permanently remove the demo database from the database server.
DROP DATABASE demo;