My first post! 🙂
I am currently doing a search of a list of data elements (like 15) from a specific table. The goal is to see if they are being UPDATEd or INSERTed in any of the existing ColdFusion sources we have. The site is HUGE and I am using DREAMWEAVER's FIND & REPLACE search too to look into from the root folder down, then I check the "matched text" results and in doubt, I open the source to double check if the field is in an UPDATE or INSERT statement.
So, I was wondering if there is a way to build a TABLE-WHERE-USED or FIELD-WHERE-USED approach that can be used as a reference, in order to speed up database analysis like this. Any suggestions are welcomed.
Have something to add?