This script search the tables in the database whcih has the given column name. This query looks for the column Employee_Id field in tables and list out the table names. This uses sysobjects , syscolumns system table to search the column name. sysobjects.xtype = 'u' means to look for only the user tables.
You can also search for multiple columns by adding the condition in the where clasue as follows.
syscolumns.name like '%Employee_Id%' or syscolumns.name like '%Employee_Number%'
Here it search the tables with column Employee_Id and Employee_Number.