Convert from varchar to Nvarchar SQLServer 2008

I have a table has a coulmn of type varchar I need to convert it to Nvarchar but it shows an error that I have to drop the table and recreate it :) any 开发者_运维技巧advice !!

---

Does this not work:

ALTER TABLE my_table ALTER COLUMN my_varchar_column NVARCHAR(32)

---

There is a setting that prevents SSMS from saving changes that requires tables to dropped and re-created.

You find the setting in Tools - Options - Designers.