SQL Keyword - COLUMN

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.

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

 Example 

ALTER TABLE Employees
ALTER COLUMN Emp_DOB Date;

DROP COLUMN

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

ALTER TABLE <TABLE_NAME> DROP COLUMN <COLUMN_NAME>;

Example

ALTER TABLE Employee DROP COLUMN Emp_Contact;

Summary

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