Deleting a field with phpMyAdmin’s database tables is very easy, follow the simple steps below to learn how to do it. Remember that deleting a file permanently removes it from the system, and recovery is not possible if no back up file has been created or saved separately.
Learn how to delete fields from database tables with phpMyAdmin with the demo below:
1. Sign in to phpMyAdmin.
2. To delete fields from database tables, select the “details” table at the left hand of the window.
3. A table will appear wherein the user may tick the box beside the field name. For this example check the “city” field. The “city” field will then be highlighted.
4. Click the “delete” or “drop” icon. This icon is a red “x” mark button below the table.
5. Click the “Yes” button to confirm the field deletion.
(The city field is now deleted in the database table. A message would confirm this, as it will be posted on the screen.)
6. Click the “home” icon or “house” picture to go back to the main menu of phpMyAdmin.
7. This is the end of the video tutorial on the procedure of deleting fields from database tables in phphMyAdmin.
8. Do let us know of any concerns and questions on this matter.
