Get Similar Column From All Tables

This blog explain that how to get all table name that contain a specific column.

To get all table name with specific column from database we will use the sys.columns and sys.table system view. We will use the below query.

 

Syntax

Select  t.name Table_Name, c.name column_Name
From sys.columns as c
Inner Join
sys.tables as t
on
c.Object_Id=t.Object_Id
Where c.name like '%Column_Name%'
Order By Table_Name, column_Name

Example

Select t.name Table_Name, c.name column_Name
From sys.columns as c
Inner Join
sys.tables as t
on
c.Object_Id=t.Object_Id
Where c.name like '%Coaching%'
Order By Table_Name, column_Name

Output: