Alter Column Type from Char to Varchar in sql server

Question

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.

thanks.

Answer 1

ALTER TABLE table_name  -<-- Your Table Name
 ALTER COLUMN username  VARCHAR(50) NOT NULL