Can SQL Server 2016 extract node names from JSON?
Select [key] from default OPENJSON schema.




DECLARE @json_doc nvarchar(4000) = '{"Name1":"Value1", "Name2":"Value2"}';

SELECT [key]
FROM OPENJSON(@json_doc);
GO



| key   |
| :---- |
| Name1 |
| Name2 |



dbfiddle here