T-SQL Tutorial

SQL Alter Table Alter Column


Alter Column Syntax:

ALTER TABLE table_name
ALTER COLUMN column_name data_type

Employee table:

Column nameData_type
idint
namevarchar(250)
dep_idint
addressvarchar(100)

Alter Column Example:

ALTER TABLE employee
ALTER COLUMN address varchar(400);

Alter Column Result:

Column nameData_type
idint
namevarchar(250)
dep_idint
addressvarchar(400)