Unable to change type of a table column.

[Mouktik_B]

I have a column inside a table of integer type but can't change its type. Only integer shows up when I try to change the type. what could be solution?

[Bhimashankar H · Accepted solution]

Hi @Mouktik_B ,

You won't be able to change the data type once column is created for your scenario. Here best to create new column with your specified data type.

If you want to retain the data then using bg script or fix script you can move/copy the data in your new column, apply proper data type conversion when data moving. Later based on your need either keep for any future use or delete the column.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[Bhimashankar H · Accepted solution]

Hey @Mouktik_B ,

I hope you saw my reply. 

If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. It will help future readers as well having similar kind of questions and close the thread.

Thanks,
Bhimashankar H