find particular column or table name from whole db

The solution for this is noted below

find particular column or table name from whole db

Solution

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME like '%ClaimProfessional%'
AND COLUMN_NAME LIKE '%payer%';

Try other methods by searching on the site. That is if this doesn’t work