Delete table from MySQL database in cPanel

Delete table from MySQL database in cPanel

Delete Table from MySQL Database in cPanel

This article will explain you to Delete table from Database in phpMyAdmin. It is recommended that you make a backup before you perform any destruction action, such as dropping tables. Without a backup, there will be no way to restore anything mistakenly deleted. Deleting tables in your database permanently will delete the table and all the data stored in that table. To delete the table from MySQL database in cPanel, follow the below steps

Step 1: Login to cPanel

Step 2: Click phpMyAdmin under the section Databases

Step 3: In phpMyAdmin. select the Database on the left pane

Step 4: List of the tables will be displayed along with their options

Step 5: Select the “Drop” option on the same column to delete the table in the database

Step 6: Confirmation message will be displayed and click “OK” to delete the table

Step 7: If the table contains the Foreign Key, it displays an error message and does not allow to delete. Otherwise, we can delete the table from the database successfully

Step 1 Login to cPanel.
Step 2 Click phpMyAdmin Database
Click phpMyAdmin

Click phpMyAdmin

Step 3 Select the Database on the left pane.
Select the Database

Select the Database

Step 4 List of the tables will be displayed along with their options.
List of Table will be Displayed

List of Table will be Displayed

Note: Drop Option helps to delete the Tables from the database.

Step 5 Select the “Drop” option on the same column to delete the table in the database.
Select the Drop and Delete Table in phpMyAdmin

Select the Drop and Delete Table in phpMyAdmin

Step 6 Confirmation message will be displayed and click “OK” to delete the table.
Confirmation Message will be Displayed and Click Ok

Confirmation Message will be Displayed and Click Ok

Step 7 If the table contains the Foreign Key, it displays the error message and does not allow to delete. Otherwise, we can delete the table from the database successfully.
Deleted Successfully Message will be Displayed

Deleted Successfully Message will be Displayed

Step 8 Done!

Tagged in:

,