How To Search Table By Column Name In Database

I am going to describe a Simple Sql Query for Searching the table in database by column Name.

For getting the Tables by column Name.

Select St.Name as TableName, SC.Name as CoulmnName
from sys.Tables ST
join sys.Columns SC
on SC.Object_ID = ST.Object_ID
where SC.Name like '%......ColumnName........%'

For Getting the columns by table name.

Select St.Name as TableName, SC.Name as CoulmnName
from sys.Tables ST
join sys.Columns SC
on SC.Object_ID = ST.Object_ID
where ST.Name like '%......TableName........%'

With the help of these queries we will find any table by column name or vice-versa.I hope this is helpful for searching data in db.