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.
8 comments
-
Solomon Rutzky commented
This is still an issue for SSMS v18.5 (SQL Server Management Studio - 15.0.18330.0)
-
Solomon Rutzky commented
This is still an issue for SSMS v18.0 RC1 (SQL Server Management Studio 15.0.18098.0)
-
Solomon Rutzky commented
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!
-
Solomon Rutzky commented
This is still an issue for SSMS v18.0 Preview 6 (SQL Server Management Studio 15.0.18075.0).
-
Solomon Rutzky commented
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).
-
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: