There are times (when we create a report in Crystal or SSRS or run an update statement in SQL), we want to know in which table and field a particular value resides. It can be a tedious and boring process to sift through all the table & field suspects in the DB.
Let's take an example. I want to update all the CHECKBOOK ID fields for all the Customers in the DB. I want to run an UPDATE statement such as:
UPDATE [TABLE] SET [XXXXX] WHERE CHECKBOOKID = 'BANKOFNY' and CUSTNMBR ='ABCD001'
But I do not know what fields in the RM00100 needs to be updated.