How Find Column Name Use in Which Table Using SQL

select so.name
from sysobjects so inner join syscolumns sc
ON so.id = sc.id where sc.name = 'Name'

Result :

tblStudent
tblEtc