September 13, 2002 at 7:44 am
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
September 13, 2002 at 8:02 am
Just do where table1.typeid = nnn or table2.typeid = nnn etc etc
September 13, 2002 at 8:14 am
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
September 13, 2002 at 9:31 am
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.
September 13, 2002 at 9:53 am
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.
September 13, 2002 at 11:18 am
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