To Find Out Tables list From Database which Contains Specific Columnname

If You want to Figure out Particular ColumnName Used Which Tables in Database To resolve Confusion about same name. You can Do easily using Single Command
For Example,

You use Default Database AdventureWorks. and You Want to Find out "ProductId" Columnname use Which Tables in Database. You can Execute Following Command.

USE AdventureWorks2012
GO
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%ProductID(ColumnName)%'
ORDER BY schema_name, table_name;