Delete multiple tables in database using phpMyadmin?

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. The following articles help to delete multiple tables using phpMyAdmin.

Step 1: Login to cPanel

Step 2: Click the option phpMyAdmin under the section Databases

Step 3: Select the database from the list of databases on the left pane

Step 4: Tables will be listed then select the tables which are to be deleted or click the option “Check all” to delete all tables in the database

Step 5: Click the option “Drop” from the drop down list of the menu ‘Operations’

Step 6: A confirmation message will be displayed and click “Yes” to delete all tables

Step 7: The database will update the information and displays the remaining tables

Step 1 Login to cPanel.

Step 2 Go to Database Section and select phpMyAdmin.

Select phpMyAdmin

Step 3 Select the database from the list of databases on the left pane.

Select the Database

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.

Select check all option to select all the tables

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’.

Select Drop option

Step 6 A confirmation message will be displayed. Click the button “Yes” to delete the tables in the database.

Click yes button.

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.

All tables are deleted

To delete a table from database using phpMyAdmin.

How to Delete table from Database using phpMyAdmin?