searching a DB for a particular field

  •  

    Hope this will make sense...

    I know what field a particular string of data exists in..  but I'm not sure what Table(s) this field exists in.    Is there a way to search the database in such a way that it can tell me what tables this field exists in??????

     

  • >>I know what field a particular string of data exists in

    So you know the column name ?

    Select object_name(id)

    From syscolumns

    Where name = 'YourColumnNameHere'

     

  • yes.  Column.

    Thank you MUCH!

  • Even Better.

    Select *

    From Information_Schema.columns

    where column_Name = 'YourColumnNameHere'

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply