How to get the collation name from a collation ID?

• keithy_sunny

  Mr or Mrs. 500

  Points: 566

  More actions

  October 15, 2015 at 7:56 pm

  #321544

  Hi,

  I am using SQL Server 2008. In ServerProperty function, there are two properties called “Collation” and “CollationID”. In some cases, I will only know the CollationID. Is it possible get the collation name from the CollationID? Is there a function called CollationNameFromID?

  Thanks

• SpeedySQL

  Ten Centuries

  Points: 1019

  More actions

  October 23, 2015 at 6:20 am

  #1835142

  Try this:

  SELECT DISTINCT collation

  FROM syscolumns

  WHERE collationID = 53256;

  SpeedySQL