varchar(255) to varchar(MAX)

Posted by JD on Stack Overflow See other posts from Stack Overflow or by JD
Published on 2010-04-23T03:15:48Z Indexed on 2010/04/23 3:23 UTC
Read the original article Hit count: 701

Filed under:

Is it possible to change a column type in a MS SQL 2008 database from varchar(255) to varchar(MAX) without having to drop the table and recreate?

SQL Server Management Studio throws me an error every time I try to do it using that - but to save myself a headache would be nice to know if I can change the type without having to DROP and CREATE.


© Stack Overflow or respective owner

Related posts about sql

Related posts about varchar