SQL Query to Find Column in database table.

Using This Query you will get a list of Tables in database which have the specified column.
select * from sysobjects where id in (select id from syscolumns where name like 'USER_ID')