开发者

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.

Convert from varchar to Nvarchar SQLServer 2008

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜