SSMS 21.0 Preview is still missing support for JSON data types
I can't find a workaround, it will just crash in random places
https://feedback.azure.com/d365community/idea/d2e6f106-9fb8-ef11-95f5-6045bdbfaf80
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I created a new Azure SQL database and used the Azure GUI to create a table with the new JSON data type (released May 2024). I then started the latest SSMS and connected to the Azure database. Next I tried to view the table design and received this error:
The table being loaded into memory has a user-defined data type ('json') that is not recognized. Close all of your open database diagram and table designer windows. The new data type will be recognized when you re-open the diagram or table designer.
So I closed all the items it asked me to and reopened the table designer and received the same error again. I closed SSMS and reopened and opened table designer and again received the same error. Do we need a specific version of SSMS to view the new json data type? I have version 20.1
SSMS 21.0 Preview is still missing support for JSON data types
I can't find a workaround, it will just crash in random places
https://feedback.azure.com/d365community/idea/d2e6f106-9fb8-ef11-95f5-6045bdbfaf80
Hello Brian,
It seems like you're encountering an issue with SQL Server Management Studio (SSMS) recognizing the new JSON data type in Azure SQL Database, even though you're using the latest version (20.1). Here are a few steps and considerations that might help resolve this issue:
Steps to Resolve SSMS Issue with JSON Data Type
CREATE TABLE MyJsonTable (
Id INT PRIMARY KEY,
Data JSON
);
You can execute queries like NSERT, UPDATE, and SELECT to work with JSON data directly.
Conclusion
SSMS version 20.1 should theoretically support the new JSON data type in Azure SQL Database. By ensuring SSMS is up-to-date, clearing cache, and using T-SQL for direct interaction, you should be able to work with JSON data effectively.
FYI, Azure Data Studio shows the data type as [sys].[json]; however, in the column properties shows it as bigint. Also if I try to add a new column as type sys.json it is not an option and can't be freeform typed in.
It sounds like there might be some confusion or a specific issue with how Azure Data Studio (ADS) is handling the JSON data type in Azure SQL Database. Let's address each point you mentioned:
ALTER TABLE YourTableName
ADD NewColumn JSON;
This allows you to bypass any UI limitations and directly define the column with the JSON data type.