Convert from varchar to Nvarchar SQLServer 2008

Question

I have a varchar type coulmn in my table I need to convert it to Nvarchar, but it shows an error that I have to remove from the table and recreate it :) any advice !!

Answer 1

Does this work:

ALTER TABLE my_table ALTER COLUMN my_varchar_column NVARCHAR(32) 

Answer 2

There is a setting that prevents SSMS from saving changes that need to be reset and recreated.

You will find the setting in "Tools - Options - Designers".