Page 1 of 1

How do you delete a table field in phpMyAdmin?

PostPosted: 11. August 2008 09:44
by Granpoh
Hello,

Well I know how to "add fields" to a table, but how do you "delete fields" from a table?

Thanks for all assistance

PostPosted: 11. August 2008 11:43
by Nobbie
Either use the table view dialog and click on the red cross to delete a column (not "field", its called column), or simply enter the following command in a SQL Dialogbox:

Code: Select all
ALTER TABLE `tablename` DROP `columnname`

PostPosted: 11. August 2008 12:09
by Granpoh
I was looking all over the place for a "delete" or a "remove" option.

Thanks Nobbie.