Alter Column SQL Tutorial
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) |