title: Alter Column Type from Char to Varchar in sql server
body: <p>I have a table with primary key 'username' and it's 'Char' , and I have to change it to varchar.
  There is a way to do that without lose the data? 
  cause it's primary key and cascading all the other tables.</p>
  
  <p>thanks.</p>