Change the Collation setting in MS SQL Server

How to Change the Collation Settings for specific database or how to change the Collation Settings for specific column?

This question can be found multiple times on the ms sql server forums, so I've decided to pen down it on the,Simple!! Once can use Alter Database command to change the collation settings for the specific database, below is the command you've to execute:

ALTER DATABASE testDB
COLLATE French_CI_AI ;
GO

photo credit: dorena-wm via photopin cc