List All Collations

Collation is nothing but a clause, it can be applied to a DB definition or a column definition of a table to define the collation, or to a character string expression to apply a collation cast.

The following Query will help to get list of all the collations Provides by Microsoft SQL Server.

select * from ::fn_helpcollations()

This Query will Return collation name and Description of the collation

For more details, visit http://msdn.microsoft.com/en-us/library/ms188755.aspx