Please add missing properties to COLLATIONPROPERTY built-in function and/or sys.fn_helpcollations()
The COLLATIONPROPERTY function ( https://docs.microsoft.com/en-us/sql/t-sql/functions/collation-functions-collationproperty-transact-sql ) currently reports on four properties:
CodePage, LCID, ComparisonStyle, and Version.
However, there are several other properties of collations that are not available via those properties.
sys.fn_helpcollations() doesn't have CodePage or LCID. ComparisonStyle and VersionIt can be derived by parsing the Description field, but yuck.
Solomon Rutzky commented
I originally submitted this suggestion via: