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.
Thanks for the reporting the issue. We’ll take a look at it and prioritize accordingly.
This is still an issue for SSMS v18.5 (SQL Server Management Studio - 15.0.18330.0)
This is still an issue for SSMS v18.0 RC1 (SQL Server Management Studio 15.0.18098.0)
This is still an issue for SSMS v18.0 Preview 7 (SQL Server Management Studio 15.0.18092.0).
Marko Oja commented
This is an issue also for Azure Data Warehouse schema compare. Any update would be much appreciated. Issue has been under review over a year now!
This is still an issue for SSMS v18.0 Preview 6 (SQL Server Management Studio 15.0.18075.0).
This is still an issue for SQL Server Management Studio v17.9.1 (14.0.17289.0) and SSMS v18.0 Preview 5 (SQL Server Management Studio 15.0.18068.0).
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.
I originally submitted this bug via: