alter table delete column

  ALTER TABLE Customers
DROP COLUMN ContactName;
 

ALTER TABLE "table_name" DROP "column_name";

add column in a table