-> This is used to modify size of the data type or the data type it self of an existing column without changing column name.
The ALTER TABLE.. MODIFY COLUMN statement modifies a column on an existing table. The modification can include changing the data type and attributes. To rename at the same time, use the CHANGE COLUMN ...