How to Change Database Collation to SQL Server

In that Example We will change the Database Collation from Case Insensitive to Case Sensitive. The collation Name in the picture is Finish_Swedish_CS_AS where CS stand for Case Sensitive and we will change it to Finish_Swedish_CI_AS where CI Stands for Case Insensitive.

 



Change Collation Using T-SQL:
USE [master]
GO
ALTER DATABASE [Sales] COLLATE Swedish_Finish_CI_AS
GO

Comments