MS-SQL: Convert all instances of one column type to another?

Question

I have an SQL Server 2008 database, which contains about 40 tables. Most of them contain at least a couple of varchar columns, and I want to convert every single one of those to nvarchar (of the same length). Also want to convert a number of text fields to nvarchar(MAX). Is there a simple, straightforward way to do this?

score 1 · Accepted Answer · edited May 23 '17 at 11:55

1

This seems very similar to the following question:

SQL Server Script to Update Database Columns from varchar to nvarchar...

Hope this helps!

edited May 23 '17 at 11:55

Community

1
1

answered Mar 10 '09 at 12:49

mwigdahl

16,268
7
50
64

Yep, that does it -- didn't find that in my initial search. Thanks! – DanM Mar 10 '09 at 12:54

MS-SQL: Convert all instances of one column type to another?

1 Answers1