To Find the column if you forget the table

SELECT TABLE_NAME, 
       COLUMN_NAME,
       DATA_TYPE, 
       IS_NULLABLE, 
     COLUMN_DEFAULT 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE column_name LIKE '%lettersFoundInTheColumn%'