Delete multiple tables in the database using phpMyAdmin
phpMyAdmin is one of the most popular applications for MySQL database management. It supports a wide range of operations for managing the database tables via the user interface. To delete multiple tables in the database using phpMyAdmin, follow the below steps
Step 1 Login to cPanel.
Step 2 Go to Database Section and select phpMyAdmin.
Step 3 Select the database from the list of databases on the left pane.
Step 4 It displays the list of tables present in the database and selects the tables which are to be deleted or click the option “Check all” to select all the tables in the database which is to be removed.
Step 5 Drop Option is used to delete the tables from the database. Select the option “Drop” from the drop down list of the menu ‘Operations’.
Step 6 A confirmation message will be displayed. Click the button “Yes” to delete the tables in the database.
Note: To Delete a database without checking Foreign Key, then uncheck the check box.
Step 7 The database will update the information and displays the remaining tables in the list.
To delete a table from database using phpMyAdmin.