Deleting fields from database tables with phpMyAdmin

Deleting fields from database tables with phpMyAdmin


This tutorial is going to teach you how to delete fields from database tables using phpMyAdmin. We are going to assume that you are already logged into 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.

This is the end of this tutorial. You now know how to delete a field from database tables using phpMyAdmin.






Add to Favourites Add to Favourites

Print this Article Print this Article



Was this answer helpful?

Also Read


Article Searching through a database with phpMyAdmin
This tutorial is about searching through a database using phpMyAdmin. We will assume that you are logged in to phpMyAdmin. For the purpose of...
Views: 1044

Article Exporting databases and tables with phpMyAdmin
This tutorial is to teach you how to export databases and tables with phpMyAdmin. We will assume that you are currently logged into phpMyAdmin,...
Views: 920

Article Searching through a database with phpMyAdmin
This tutorial is about searching through a database using phpMyAdmin. We will assume that you are logged in to phpMyAdmin. For the purpose of...
Views: 1044

Article Copying a database table with phpMyAdmin
This tutorial is going to teach you how to copy a database table with phpMyAdmin. For the purposes of the tutorial, we will assume that you are...
Views: 949

Article Inserting fields into database tables with phpMyAdmin
This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into database tables using phpMyAdmin. We will assume that...
Views: 866


 
Devlopemt Developing Applications in Agile Mode and managing Projects with specifications of Platform, technology and Backend is what Dhrusoft offers to its customers within the range of technology and services supported ....
Learn More
Devlopemt FOR WEB DESIGN, WEB APPLICATION DEVELOPMENT, PHP WEB DEVELOPMENT, MOBILE APPLICATION ETC... We Appreciate your Interest in our services.
Click Here....
Hosting Security Resources Contact Dhrusoft:
-Web Hosting
-Dedicated server
-Cloud/VPS Hosting
-Domain Names
-Email Hosting
-Web Designing
-SSL Certificate
-Firewalls and Server Security
-Private Domain Registration
-Smart Card Solution

Keep in touch with us :

RSS Twitter Facebook YouTube


Copyright@2001-2012 Dhru.com - All Rights Reserved