Delete multiple tables in database using phpMyadmin?

0
12
Delete multiple tables

Delete multiple tables

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.
Go to Database Section and Select phpMyAdmin.
Select phpMyAdmin
Step 3 Select the database from the list of databases on the left pane.
View phpMyAdmin Main Page. Then Go to Left pane. It has a list of Database available.
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.
It displays the List of Tables present in the database and Select all  the tables in the database, Click Check all button.
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 the operation in the drop down list.
Select Drop option
Step 6 A confirmation message will be displayed. Click the button “Yes” to delete the tables in the database.
To Delete a database without checking Foreign Key then unchecked the check box. To Delete the tables,Click yes button.
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.
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?

LEAVE A REPLY

Please enter your comment!
Please enter your name here