Getting Information About Collations
You can use the following catalog views and functions to obtain collation information.
Returns information about the collation of a database.
Returns information about the collation of a column of a table or view.
Returns information about collations in SQL Server.
Returns a list of available collations in SQL Server.
Collations marked for deprecation in SQL Server 2008 or future versions of SQL Server are not included in the list of available collations returned by fn_helpcollations. For more information about deprecated collations in SQL Server 2008, see Deprecated Database Engine Features in SQL Server 2008 R2.