How to change the database collation

Posted on January 2, 2012 by vivekjohari
To change the collation of an database following commands can be used:

ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE  [database name]  COLLATE Newcollation
ALTER DATABASE  [database name]  SET MULTI_USER
For example , suppose if the name of your database is learningdb and you want to change the collation to the collation SQL_Latin1_General_CP1257_CI_AS, then following commands can be used:-
ALTER DATABASE 
learningdb  SET SINGLE_USER WITH ROLLBACKIMMEDIATE
ALTER DATABASE 
learningdb  COLLATE SQL_Latin1_General_CP1257_CI_AS
ALTER DATABASE 
learningdb  SET MULTI_USER

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Basic Concepts, SQL Server and tagged . Bookmark the permalink.

31 Responses to How to change the database collation

  1. Pingback: รับทำ seo สายดำ

  2. Pingback: engagement rings

  3. Pingback: w.88.com

  4. Pingback: Nightmare Market Exit Scam

  5. Pingback: w88

  6. Pingback: บริษัท ออล ครีเอตี้ แลนด์ จำกัด

  7. Pingback: 바카라사이트

  8. Pingback: Mazlo

  9. Pingback: Website

  10. Pingback: Home Inspection Champaign IL

  11. Pingback: cbd

  12. Pingback: Darknet Empire Market

  13. Pingback: Crystal Meth

  14. Pingback: Darknet Drogen

  15. Pingback: bandar ceme online

  16. Pingback: Stock Markets Keep Making New Highs But The System Implodes Gold Silver Rallying Soon

  17. Pingback: roofing in forney

  18. Pingback: pelangiqq

  19. Pingback: indo qq

  20. Pingback: bong88.com.vn

  21. Pingback: www.parisqq1.site

  22. Pingback: Seedsman Discount Code

  23. Pingback: pasarqq

  24. Pingback: 2015louisvuittonoutlet

  25. Pingback: poker99 online

  26. Pingback: 12 bet.com

  27. Pingback: www.1poker99.com

  28. Pingback: đăng ký fun88

  29. Pingback: duratrans nyc

  30. Pingback: Stocks and Gold Silver PreMarket TA for This Week

  31. Pingback: https://www.klikdokter.com/

Leave a Reply