Find All Table Names Using Column Name

select name, object_name(id) from syscolumns where name='column_name'