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 |
|
columbo
Starting Member
2 Posts |
 Posted - 2007-02-26 : 07:59:24
|
| Hi all!!I'm trying to do some work on two tables with different collationsI know you can assign a new collation to a table with:Alter table TABLENAME alter column [COLUMN_NAME] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULLBut I have loads of columns - is there a way to to an entire table in one go?Thanks very muchC |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-26 : 08:06:06
|
| No. You will have to do it manually for each column.Also note, changing collation does not affect your existing data in the table.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
columbo
Starting Member
2 Posts |
Posted - 2007-02-26 : 09:11:43
|
| Thanks Harsh,thanks for your help.CheersC |
|
|
|
|
|
|
Collate an entire table.