Post reply

Finding a column name in a database

  • September 22, 2006 at 3:46 pm

    #71023

    Is there a script out there that will query a database and tell me where a column resides??  I have a column I need to find where it is storing info and I don't want to go thru each table looking for it...

    thanks for the help!!

    Thank you!!,

    Angelindiego

  • September 22, 2006 at 3:57 pm

    #662047

    You can get this information from Information_schema views like this

    select

    * from information_schema.columns where column_name like 'colname%'

  • September 22, 2006 at 4:07 pm

    #662050

    thank you so much for such a quick response!!

    Thank you!!,

    Angelindiego

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

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