Re: Query help

From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >Obnoxio The Clown wrote: > > > > From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > > > > > >Obnoxio The Clown wrote: > > > > > > > > From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > > > > > > > > > >Navdeep Virk wrote: > > > > > > > > > > > > I would like to find the tables which contain the column name >foobar > > > > > > from say 270 odd tables. can this be done by query the systabs. > > > > > > > > > >Yes, something like: > > > > > > > > > > SELECT tabname > > > > > FROM systables t, syscolumns c > > > > > WHERE t.tabid = c.tabid > > > > > AND c.colname = "foobar"> > > > > > > > Didn't I just say that? > > > > > >Yes. Didn't you know it's rude to copy? > > > > Of course I did. I already got 90% of the audience with my last cheap >shot, > > now I'm going for you. :0) > >Well I certainly wasn't going to PAY for it! :-) That's funny... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com