Querying Property Data in Umbraco 9+

Today I helped my friend James who needed to see the data saved in the database for a property on a node. He was interested in how it was stored.

I found some SQL from Marc Goodson and made a note of it.

I adapted it and decided to keep a record of it here for later.

DECLARE @yourNodeId as INT

SET @yourNodeId = 1141

SELECT * 
FROM [umbracoPropertyData] upd 
INNER JOIN [umbracoContentVersion] ucv 
    ON upd.versionId = ucv.Id 
WHERE ucv.[current] = 1 
        AND ucv.Nodeid = @yourNodeId

SQL to see the property values that are stored in the database for a specific node id