I would like to know how to delete a column in a table, without deleting the rest of the columns.
ALTER TABLE NameofTable DROP COLUMN ColumnName;