Aug 10

Written by: Steve Gray
8/10/2010 4:51 PM 

It is occasionally necessary to find all the occurrences of a field name in a SQL Server database. This script will seacrh the database and return all the tables that contain a certain field name.

select sysobjects.name
    from syscolumns
        left join sysobjects on sysobjects.id = syscolumns.id
    where syscolumns.name like 'myFieldName'
    order by 1