How Can We Change The Data Type Of A Column Of A Table?

1.	How Can We Change The Data Type Of A Column Of A Table?
Answer» This will change the DATA TYPE of a column: ALTER TABLE table_name CHANGE colm_name same_colm_name [NEW data type]. This will change the data type of a column: ALTER TABLE table_name CHANGE colm_name same_colm_name [new data type].

Answer»

This will change the DATA TYPE of a column:
ALTER TABLE table_name CHANGE colm_name same_colm_name [NEW data type].

This will change the data type of a column:
ALTER TABLE table_name CHANGE colm_name same_colm_name [new data type].

Discussion