I have customers that come to me with reports with information from our SW database from years past asking for the SQL Query.
The Reports they have were made through the Web Console.
I know how to find the table name and column when I have something to go off of, but what if I dont know what table or column the information is coming from?
SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE '%YearAdded%'
Example:
If the Output Record is '1982', can I perform a Select search for just 1982 from all the tables and columns at once to give me a better picture of where the information came from originally?
