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';