To delete table from the database, you can use DROP TABLE statement:
DROP TABLE [IF EXISTS] table_name [, table_name…]
MySQL allows you to drop multiple tables at once by listing them all, each separated by a comma. IF EXISTS is used to prevent you from deleting table which does not exist in the database.
DROP TABLE student;