Find column name in all tables in database

To find the column name in all tables within the database.

Here is the query to find the column in all the tables of particular database in MS SQL Server

Select * From INFORMATION_SCHEMA.COLUMNS Where column_name = 'Emp_Name'

This query will return the list of tables, which contain the column this column. (here for example, "Emp_Name")