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;

Leave a Comment