SSMS 17.3 IntelliSense does not recognize CATALOG_DEFAULT as a valid collation
Management Studio, with IntelliSense enabled, does not seem to know that "CATALOG_DEFAULT" is a valid collation option. The name is underlined in red with a tool tip of:
Invalid Collation 'CATALOG_DEFAULT'.
Yet, it clearly is not invalid since it does work :-).
I have observed this behavior in SSMS 17.1 and now in 17.3.
I have tested with both SQL Server 2012 and 2016.
1
vote
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
Upvotes: 1
2 comments
-
Solomon Rutzky
commented
This is still an issue in SSMS 17.5:
SELECT 'a' COLLATE CATALOG_DEFAULT;
That statement works just fine, but IntelliSense indicates that it is an invalid Collation.
-
Solomon Rutzky
commented
I originally submitted this bug via: