Deleting fields from database tables with phpMyAdmin

For the purpose of this tutorial, we will use a database with one table for an example. The database will be listed in the left hand window, which is blue, with the table listed below it. The right hand window is where all the activity will take place.

Let's get started on deleting fields from database tables. Begin by selecting the table(from the left hand window) that you wish to delete fields from, and clicking on it. That will bring up all the details about the table in the right hand window. You will see a list, in chart form, of the fields contained in the table. Find the field you wish to delete. In front of the field name, there is a check box. Mark this box. Then below the list you will find the Delete Icon. It is a big red X. Click on it. A screen will ask you to confirm 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 deleted field is gone. A message also confirms that your action was successful.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Managing MySQL Databases With PHPMyAdmin

On the main cPanel page, scroll down to the section called Databases, and click on the icon named...

How To Create A MySQL Database

On the main cPanel page, scroll down to the Database section, and click on the MySQL Databases...

Importing databases and tables with phpMyAdmin

The phpMyAdmin main screen is broken into two sections. The left hand side is blue, and this is...

Inserting fields into database tables with phpMyAdmin

Let's begin by locating the database name in the blue section on the left of the phpMyAdmin...

Deleting tables in a database with phpMyAdmin

For this tutorial, we will be using a database with two tables for the example. In the left hand...