Can you help me locate a for the table and column name for a specific value? See I only know the specific data but no idea where it resides.
SELECT *
FROM <table_which_i_don't_know_yet>
WHERE <column_name_which_i_don't_know_yet> = <value_that_i_know_of>
What I just found is look for a table with a specific column...
select *
from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME like '%clientid%'
order by TABLE_NAME