we have a study where a bunch of fields have URLs that contain 'EHR_reporting'. That is the previous name of the EHR module. I need to change all these URLs. if i run this query:

SELECT *
  FROM exp.propertydescriptor
  where url like '%reporting%'

i think i'm finding all these fields. If I update the url field on these rows, will I change all the URL metadata? is that stored anywhere else? it is not in any XML files in our module. Are there any undue risks from doing this? Is metadata from different types of tables stored somewhere else?

Every time I ask one of these questions you warn that this isnt how we're supposed to make changes; however, it really seems like a faster and more fool proof (i cant miss anything this way). A different approach would be to try to reload the study with updated XML files; however, this is neither a fast nor error free process either from our experience.

Thanks for the help.