The following code should be run to obtain the list in which tables a column name is wanted to be searched in MS SQL Server.

SELECT c.name AS ColumnName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%{Column Name to Search}%'