Query to list all tables containing a column

Create procedure sp_helpCol(
@columnName varchar(50)
)
as
select object_name(id) 'Table list where this column is used/exist' 
from syscolumns where name = @columnName