How to change database collation in MSSQL

To do it use the following query:

ALTER DATABASE database_name COLLATE collation_name

(for example for the database withname “mydatabase” and greek collation the command would be: ALTER DATABASE mydatabase COLLATE GREEK_CI_AS)

You can get current collation and other properties of the database by the
following query:
sp_helpdb database_name