DROP COLUMN

The DROP COLUMN command is employed to remove a column from a pre-existing table.

The following SQL eliminates the “ContactName” column from the “Customers” table:

ALTER TABLE Customers
DROP COLUMN ContactName;