Answer: With the help of Alter Column,we can change data-type of a column.
Syntax:-
Alter Table table_name
Alter Column column_name datatype.
For Example:-
Alter Table employee_master
Alter Column employee_code varchar(30);
Asked In: Many Interviews |
Alert Moderator