Altering Data Length of a Primary Key Column

,

This is not an article or a script. I am posting this just to share my experience and I feel it can save a lot of time in a specific situation.

Problem

– We have a table let’s say Customer and this table has an alpha numeric primary

key CustomerID varchar(10). Due to unexpected growth in volume of data we

figure out varchar(10) was not sufficient and we decided to make it varchar(50).

When

Rate

Share

Share

Rate