MULTI TABLE SEARCH

  • Does anyone know how to search multiple tables with the same column name. For example if I have table1 table2 table3 and there is column called typeid on all there, is there a way to search all those tables where a WHERE clause to weed out data. Thanks

  • Just do where table1.typeid = nnn or table2.typeid = nnn etc etc

  • I guess I should have also said it was 100's of tables and columns so it would be tough to type out all of them

  • There was a script written by Narayana Vyas Kondreddi that will search all columns in every (user) table in one database. I think you can modify that script very easily to only search for one specific column in all user tables.

  • There was a script written by Narayana Vyas Kondreddi that will search all columns in every (user) table in one database. I think you can modify that script very easily to only search for one specific column in all user tables.

  • Is the sample on this website. Do you have a short cut to the article?

Viewing 6 posts - 1 through 5 (of 5 total)

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