2

I have a table which has about 8,000 rows and I wanna change a column from varchar(1000) to varchar(max) I typed 

alter table TABLENAME alter column COLUMNNAME varchar(MAX)

and it didn't work. How can I change the data type of the column? Or do I have to write varchar(5000) or something instead of varchar(MAX)?? Thank you.

juergen d
  • 201,996
  • 37
  • 293
  • 362
Dahye Baek
  • 23
  • 3
  • Thank you, Mike. But I turned off that option before I did that work. Also it is not related to any other tables. – Dahye Baek Oct 15 '13 at 00:23

1 Answers1

1

The following thread here on SO contains answer to your question. Take note that your table might get dropped and re-created during the process.

convert to varchar(max)

Community
  • 1
  • 1
Mike Caleb
  • 81
  • 2