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.
精彩评论