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 |
|
rd_innovatives
Starting Member
18 Posts |
 Posted - 2007-05-24 : 09:23:34
|
| Hi All,Hope that our db friends are all well ... :-)Can any one help me out of the problem .. actually I have an existing database and I need to change the collation (Case Sensitivity ) of that db at the column level ... I can change the collation at DB level by the CS_AS_KS_WS (Case Sensitive, Accent Sensitive ... etc)but I dont know how to change the Collation at column level (Case Sensitive) ..any thing I can do through Enterprise manager or by query ...Thanks in Advance .. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-24 : 09:33:30
|
| You can change column level collation only by using ALTER TABLE statement like this:ALTER TABLE SomeTable ALTER COLUMN SomeCol varchar(10) COLLATE Latin1_General_CI_ASBut this can be very cumbersome if it has to be done for large number of columns.Another option can be:1. creating another database with desired collation2. create all desired DB-objects in the new database3. bulk copy data into new database4. drop original database, and5. rename new databaseHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Column Level Collation