Convert varchar to text

I need to convert a field from Varchar(255) to a Text field. How is that done in MSSQL 6.5 ?

(The table contains data)

Thanks for your help...
cisDKAsked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
It can be done only in the following steps:
Rename old table
create new table with type changed
insert data into a new table
drop old table
There is no way in SQL server to change datatype in existing table.
0
 
cisDKAuthor Commented:
Edited text of question
0
 
cisDKAuthor Commented:
Ok, too bad... :/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.