11 February 2012 By Praveen Macherla 488 views One Comment
0 Flares 0 0 Flares ×

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;

Tags: ,

  • Niranjan sahu

    Thank-Q very much..This is a very helpful website..