Delete table from Database using phpMyAdmin
A database is an organized collection of data so that it can be easily accessed, managed and updated. The data is indexed easier to find the relevant information quickly. Most of the databases contain multiple tables with several different fileds. To delete a table from a database, follow the below steps
Step 2: Select the option phpMyAdmin from the section Databases
Step 3: Select the database from the list of databases on the left pane
Step 4: List of 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: A confirmation message will be displayed and click the button OK
Step 7: If a table has foreign key, an error message will be displayed and it will not be deleted
Step 1 Login to cPanel.
Step 2 Select the option phpMyAdmin from the section Databases.
Click on to phpMyAdmin
Step 3 Select the database from the list of databases on the left pane.
Select the Database
Step 4 List of tables will be displayed along with their options.
View the list of tables
Step 5 Drop Option is used to delete the tables from the database. Select the Drop option on the same column to delete the table in the database.
View the drop option
Step 6 Confirmation message will be displayed and Click Ok to delete the table.
Click the button OK to delete the table
Step 7 If a 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.
Delete the table from Database