Column Search in a database

• control

  SSCommitted

  Points: 1630

  More actions

  January 16, 2003 at 7:05 am

  #79618

  Do anyone have a simple query that I can use to search for a column in a database with a number of tables? Mind you I do not know the table which the column is.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  January 16, 2003 at 7:15 am

  #446494

  Try something like this. This will give you all the tables, and/or views that the column is used in.

  select table_name from information_schema.columns where column_name = 'mycolumn'

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP