COLUMN Keyword

The column keyword is used when we want to modify any column or delete any column.

ALTER COLUMN

The Alter Column is used to modify the column data type.

SQL
ALTER TABLE <TABLE_NAME> ALTER COLUMN <COLUMN_NAME> <DATATYPE>;

Example

SQL
ALTER TABLE Employees
ALTER COLUMN Emp_DOB Date;

DROP COLUMN

The Drop Column is used to delete the column of an existing table.

SQL
ALTER TABLE <TABLE_NAME> DROP COLUMN <COLUMN_NAME>;

Example

SQL
ALTER TABLE Employee DROP COLUMN Emp_Contact;

Summary

The column keyword is used when we want to modify any column or delete any column.