Search column name in tables in SQL Database

select
sc.name as col_name,so.name as table_name from syscolumns sc inner join sysobjects so on so.id=sc.id where sc.name like 'column_name' and so.xtype='U'