Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
er_sql
Starting Member
1 Post |
 Posted - 2004-11-15 : 12:39:57
|
| Hi, I need some help.I have some Sql Server Databases online and I need to change the collation to all Varchar Datatype. My actual Collation is Modern_Spanish_CI_AS but I have other Collation in my tables that I have ready created.How can I change It?, Do I Have to do this one by one or Can I make it for all Tables?Tnak´s for your helpER_SQL |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-15 : 13:42:46
|
| You can write a script that will do it for all your tables. You will use the ALTER TABLE command, I beleive, and specify the new collation for each varchar column. BEWARE, however, large tables will take a LOT of transaction log to do this to...you might be better copying the data out, dropping and re-creating it, and then copying the data back in. |
 |
|
|
|
|
|
Collation Help