select sysobjects.nameSource - Steve Gray
left join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name like 'myFieldName'
order by 1
Thursday, August 27, 2009
Find All Occurences of a Specific Field Name in SQL Server
Here's a useful T-SQL script that will identify every table that has a field with a specific name: