Hey all… fairly new to SQL and to this new company. They’ve asked me
to validate data for a feature of the software by comparing raw data to
what’s being written into the table.
The problem? No one is sure what the name of the table is! The
person I took over for left no notes and was apparently the “expert”
(which means he left with his ‘secrets’) on this particular set of data.
Someone thought the table included the word “effective”, but this
particular application has too many table to search through one by
one. Is there a query or a way to look for this word in a table name?
Thanks in advance to whomever can help!
