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: