DXC Technology Interview Question

How to change column type in DB after value has been inserted without removing earlier value

Interview Answer

Anonymous

Nov 30, 2018

Actually you cant! You have to create a new column with the updated datatype and then you will update the rows into it and have to take care if type.