Erasing fields from database tables with phpMyAdmin Print

  • 252

This article is going to teach you how you can erase fields from database tables using phpMyAdmin. We are going to think that you are already signed into phpMyAdmin. For the purpose of this article, we will use a database with one table for an example. The database would be listed in the left hand window, which is blue, with the table listed beneath it. The right hand window is where all the activity will take place.

Let's get started on erasing fields from database tables. Begin by choosing the tablefrom the left hand window that you need to erase fields from, and hitting on it. That will bring up all the information about the table in the right hand window. You will find a list, in chart form, of the fields contained in the table. Look for the field you need to erase. In front of the field name, there is a check box. Mark this box. Then beneath the list you will see the Delete Icon. It is a big red X. Simply click on it. A display will ask you to verify that you really want to delete or Drop the Field? Click Yes to confirm. Now the window will show the list of table fields, and the erased field is gone. A message also confirms that your action was a success.

This is the end of this article. You already know how to erase a field from database tables using phpMyAdmin.


Was this answer helpful?

« Back