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
Reference: http://msdn.microsoft.com/en-us/library/ms187963.aspx