Search Column name from all tables.

 SELECT DISTINCT TABLE_NAME , COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME like '%semester%'