Check Database Collation

Syntax:

 DATABASEPROPERTYEX(Database, Property);

SELECT DATABASEPROPERTYEX('dbname', 'Collation') as Collation ;

 Result:

  Collation

  Latin1_General_CI_AI

To Change Collate

ALTER DATABASE dabasename COLLATE Collatename ;

1)ALTER DATABASE Test COLLATE French_CI_AS ;

0r

2)Right Click database, choose properties -> options

  select Collation