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



No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: