search for column in DB

SELECT b.TABLE_NAME AS TableName, a.COLUMN_NAME

FROM (SELECT TABLE_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS) AS a INNER JOIN

(SELECT TABLE_NAME, TABLE_TYPE

FROM INFORMATION_SCHEMA.TABLES

WHERE (TABLE_TYPE = 'base table')) AS b ON a.TABLE_NAME = b.TABLE_NAME

WHERE (a.COLUMN_NAME = 'ColumnSearched')