Erasing tables in a database with phpMyAdmin Print

  • 171

This article is to teach you concerning specific processes in phpMyAdmin. We are going to learn how to erase a table in a database with phpMyAdmin. For the goal of this article, we will assume that you are already signed into phpMyAdmin.

For this article, we will be using a database with two tables for the example. In the left hand window, the blue screen, you will see the name of the database, with the names of the tables listed below that name. Now let's know how to erase one of the tables. Begin by picking the table you like to erase in the blue window, by clicking on it. This will show all the table data in the big window on the right hand side.

There is a list of fields that are in the table. You can erase individual fields from the table by choosing them in this list, using the check box at the start of each field. You would then select on the Delete icon, which is located below the fields table, a large red X. That would erase the selected field.

You're now going to find out how to erase the entire table and everything in it. In the menu at the top of the white screen, hit on the Drop button. A pop-up will ask you to confirm that you really want to drop the table. As soon as you are definite, click on the OK button to confirm. The display will now show a confirmation that the table has been dropped, and the table won't be listed in the databases list of tables.( This list is in the blue screen).

Click on the Home icon on the left hand side, and this will take you to the main screen. This is the end of this article. You now know how to erase tables from a database using phpMyAdmin.


Was this answer helpful?

« Back