Where do I find dynamic property information in database, on which table. Is it the same on episerver 4 and 5.
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
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.pkIDwhere def.fkPageTypeID is NULL
I figured out later that it is in tblProperty table.