Hi shrirangh it's always a good idea to follow the below mention steps in order to change the data type of a table:
1. Write and execute the alter script to truncate the target column (But not the table)
2. Write and execute the alter script to change…