[Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

change nvarchar (50) field to (max)

how do i update the data type of a field in a production DB from nvarchar(50) to nvarchar(max)
when i try this in design view in sql 2005 i get a message that said the table needs to be dropped and re-created. this is not good.

any other options that will work on a production DB ?
1 Solution
Aneesh RetnakaranDatabase AdministratorCommented:
ALTER table tableName
alter column columnName nvarchar(max)
This worked for me..
create table c1(a nvarchar(50));
alter table c1 alter column a nvarchar(max);

Open in new window

supergirl2008Author Commented:
strange that i got the error that the table needs to be dropped and recreated, but the change was done on the table regardless.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now