How to find column names from SQL Table

SELECT

table_schema,

table_name,

column_name

FROM

INFORMATION_SCHEMA.columns

where column_name Like '%Composite%'

It will return all table where the specific column existing.