locate all tables in a db that contain a specific column name

• UncleRoydee

  SSC Enthusiast

  Points: 160

  More actions

  April 28, 2004 at 3:31 pm

  #359629

  Hi Ya'll, (Getting my southern drawl together for the Orlando PASS Conference!)

  I need to get a list of tables in a fairly large database (that I recently inherited) that contain a specific Column name. I think there are some queries that are comparing values from the same column name in different tables even though there is no primary key relationship between these two or more tables.

  I looked in system tables and also in the system stored procedures, but haven't found an answer yet.

  I appreciate all replies.

  By ya'll!

• smv929

  SSCrazy

  Points: 2889

  More actions

  April 28, 2004 at 4:14 pm

  #504583

  try...

  Select table_name from information_schema.columns where column_name like '%text%'

  
  smv929

• UncleRoydee

  SSC Enthusiast

  Points: 160

  More actions

  April 29, 2004 at 6:35 am

  #504651

  Surprise! The column name is unique within tables in the database but is referenced by numerous Views.

  Thanks for the assist, smv929, it worked perfectly.

  UR