COLLATIONPROPERTY
statements #tsql#statements
Syntax
COLLATIONPROPERTY ( 'collation_name' , 'property' )Return Type
sql_variant
Property Descriptions
| Property | Return Type | Description |
|---|---|---|
| CodePage | int | Code page of the collation. |
| LCID | int | Windows LCID of the collation. |
| ComparisonStyle | int | Windows comparison style of the collation. |
| Version | int | Version of the collation. |
| SortOrder | tinyint | Sort order ID of the collation (SQL Server collations only). |
Remarks
Returns information about a specified collation.
Example
SELECT COLLATIONPROPERTY('database_name', 'CodePage') AS CodePage;