What is the purpose of Fn_helpcollations() ?

Answer:

To get a list of all sql server collations we can execute "Fn_helpcollations() " system function. This will return name and description of various collations.

e.g.

select * from fn_helpcollations()

Result(Partial)

name description
Albanian_BIN Albanian, binary sort
Albanian_BIN2 Albanian, binary code point comparison sort
Albanian_CI_AI Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-insensitive
Albanian_CI_AI_WS Albanian, case-insensitive, accent-insensitive, kanatype-insensitive, width-sensitive
Albanian_CI_AI_KS Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-insensitive
Albanian_CI_AI_KS_WS Albanian, case-insensitive, accent-insensitive, kanatype-sensitive, width-sensitive