Product:
Microsoft SQL server 2016

Issue:
Want a list of all collation settings on the databases.

Solution:

Run this SQL query on server:

USE Master
GO
SELECT
 NAME, 
 COLLATION_NAME
FROM sys.Databases
 ORDER BY DATABASE_ID ASC
GO

More information:

https://www.mssqltips.com/sqlservertip/2513/identify-sql-server-instance-and-database-collation-using-tsql-and-ssms/

https://sqlquantumleap.com/2018/06/11/changing-the-collation-of-the-instance-and-all-columns-across-all-user-databases-what-could-possibly-go-wrong/

Most common are:  SQL_Latin1_General_CP1_CI_AS