T-SQL (Microsoft SQL Server): How to find table by column name:

Run this to find table with column name:

SELECT o.name AS TableName, c.name AS ColumName
FROM syscolumns c JOIN sysobjects o
 ON c.id = o.id
WHERE  c.name like '%account%'
ORDER BY o.name, c.name

more...