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
  1. Select t.name Table_Name, c.name column_Name
  2. From sys.columns as c
  3. Inner Join
  4. sys.tables as t
  5. on
  6. c.Object_Id=t.Object_Id
  7. Where c.name like '%Column_Name%'
  8. Order By Table_Name, column_Name
Example
  1. Select t.name Table_Name, c.name column_Name
  2. From sys.columns as c
  3. Inner Join
  4. sys.tables as t
  5. on
  6. c.Object_Id=t.Object_Id
  7. Where c.name like '%Coaching%'
  8. Order By Table_Name, column_Name
Output: