Alter Column Syntax:
ALTER TABLE table_name
ALTER COLUMN column_name data_type
Employee table:
Column name | Data_type |
---|---|
id | int |
name | varchar(250) |
dep_id | int |
address | varchar(100) |
Alter Column Example:
ALTER TABLE employee
ALTER COLUMN address varchar(400);
Alter Column Result:
Column name | Data_type |
---|---|
id | int |
name | varchar(250) |
dep_id | int |
address | varchar(400) |