Getting collation descriptions

Just an update as I noticed I forgot to say how to get the names and descriptions of the collations your SQL Server supports