fn_helpcollations

Returns a list of all collations.

Syntax

fn_helpcollations ( );

Tables Returned

fn_helpcollations returns the following information:

Column name

Data type

Description

Name

sysname

Standard collation name

Description

nvarchar(1000)

Description of the collation

Example

SELECT Name, Description FROM fn_helpcollations()
 WHERE Name like 'L%'
   AND Description LIKE '% binary sort';

See Also