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