Wednesday, June 3, 2009

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

No comments:

Post a Comment