SQL Schema Searching - Columns

-- column search

select table_name
from information_schema.columns
where column_name = 'columnname'