The Property is of course on tblProperty table and if you know the pageId and propertyId you can get it by using sql statment 

select  * from [dbo].[tblProperty] WHERE fkPageID=xxxx and fkPageDefinitionID=yyyy

regards

You can distinguish a dynamic property from an "ordinary" property by looking at column fkPageTypeID in tblPageDefinition (in CMS7 it is fkContentTypeID in tblPropertyDefinition). For dynamic properties is the column value NULL (meaning they are not bound to a specific page/content type).

so you can e.g. get all dynamic property values as:

select * from [dbo].[tblProperty] as prop inner join
[dbo].[tblPageDefinition] as def on prop.fkPageDefinitionID = def.pkID
where def.fkPageTypeID is NULL

Thanks Johan,

I figured out later that it is in tblProperty table.

Regards