How I find a particular column name within all tables of SQL database.

Most of the time, we have to find such a column from the whole database. The solution is provided below:

For example: I have a database named Employee, I have more than one table where employee_id column is present.

Here I am searching for column_name which contains employee_id within its name. It will return all the tables and respective columns containing employee_id