dropping a column using alter code example
Example 1: alter table delete column
ALTER TABLE "table_name" DROP "column_name";
Example 2: sql query alter table drop column
ALTER TABLE Customers
DROP COLUMN ContactName;
ALTER TABLE "table_name" DROP "column_name";
ALTER TABLE Customers
DROP COLUMN ContactName;