Post reply

searching a DB for a particular field

  • February 2, 2006 at 1:04 pm

    #112374

     

    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??????

     

  • February 2, 2006 at 1:07 pm

    #618492

    >>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'

     

  • February 2, 2006 at 1:19 pm

    #618501

    yes.  Column.

    Thank you MUCH!

  • February 2, 2006 at 2:56 pm

    #618529

    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