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

• Functions