I'm trying to change a specific word to another word on all pages on my website via SQL queries to the database. I have managed to do this by doing a update query on the views tblProperty and tblPageLanguage. Nothing breaks and I can't find any trace of the replaced word on the site, except for one place.
When I enter editor mode and edit a page, the old word is still present in the properties view. As soon as I make any edit to, for example, a XHTML-property and publish, the old words once again appears on the page.
My question is where this text is saved in the SQL database.
I think this is because the content is cached.
When you enter edit mode, you do not get the data directly from the database, but from the cached version.
To verify, run iisreset after manually updating the database.
Option for clearing cache from admin mode: https://world.episerver.com/blogs/joe-mayberry/dates/2019/2/working-with-the-local-object-cache/
Thank you for your answer, Tomas!
Turns out there is a view in the database called "tblWorkProperty" that had the data I was looking for. However, this might be a special case and my solution may not work for everyone. Just thought I would make an update if anyone else runs into the same problem as me.
The table tblContentProperty holds property values for published versions of your content, and tblWorkContentProperty holds property values for previously published content versions and drafts.