Find Json Schema In Sql Server

I have JSON in a field, but I need to check it's schema before I process it. I need to know if anything has been added or removed from the schema. Is there a way to extract the JSO

Solution 1:

SQL Server don't support any json schema binding.

If your JSON is simple or flat, you can use

SELECT[key]FROMOPENJSON(@json)

to find all keys on the first level and compare them with some expected key set.