Usage and Examples of SQL DROP COLUMN Keyword

SQL Keyword Reference

DROP COLUMN (Delete Column)

The DROP COLUMN command is used to delete a column from an existing table.

The following SQL statement deletes the 'ContactName' column from the 'Customers' table:

　　ALTER TABLE Customers
DROP COLUMN ContactName;

SQL Keyword Reference