How do i find out the table from the database where i have only the record. From that record how can i dentify which table it will exist in. From the below query i can find out the table names is any possibilities to find out the tables based on records...
SELECT T.NAME AS TABLE_NAME,SCHEMA_NAME(SCHEMA_ID) AS SCHEMA_NAME,C.NAME AS COLUMN_NAME FROM SYS.tables AS T
SYS.columns as C ON T.object_id=C.object_id WHERE C.name LIKE 'gpi%'