The ALTER TABLE ... DROP COLUMN command is used to delete a column.
ALTER TABLE tableName DROP COLUMN|COLUMNS cols
Parameter |
Description |
|---|---|
tableName |
Table name. |
cols |
Columns to be deleted. You can specify multiple columns. |
ALTER TABLE table1 DROP COLUMN a.b.c ALTER TABLE table1 DROP COLUMNS a.b.c, x, y
a.b.c indicates the full path of a nested column. For details about the nested column rules, see Adding a Column.
You can run the DESCRIBE command to check which column is deleted.