Where is it?

Have you ever needed to find a data-point in a large database, but not known which table it was in?

This query might help.

SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%name here%'