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