Delete a column in table (PhpMyAdmin/HeidiSQL)

Question

I would like to know how to delete a column in a table, without deleting the rest of the columns.

Answer 1

If this column has foreign key you have to go in "Structure" tab, click on "see relational view" below the fields. Here you can remove the foreign keys by selecting an empty value in the dropdown. After that you should drop column using following comment : ALTER TABLE 'tableName' DROP COLUMN 'columnName';

Answer 2

ALTER TABLE NameofTable DROP COLUMN ColumnName;