Re: [SQL] Find all instances of a column in the entire database.

2008-05-16 Thread Chris Browne
[EMAIL PROTECTED] ("Gavin 'Beau' Baumanis") writes: > I am hoping that you might be able to give me some assistance with the > following task! > I have a database with nearly 200 tables and I need to find all tables > that contain a column of myColumnName. > > I was hoping there might be a built-in

Re: [SQL] Find all instances of a column in the entire database.

2008-05-16 Thread A. Kretschmer
am Sat, dem 17.05.2008, um 0:04:05 +1000 mailte Gavin 'Beau' Baumanis folgendes: > Hi depesz, > > Thanks very much! > That works wonderfully well... > > Is this listed in the manual anywhere? because after two hours of > reading, I didn't find it anywhere! Of course, the whole information

Re: [SQL] Find all instances of a column in the entire database.

2008-05-16 Thread Gavin 'Beau' Baumanis
Hi depesz, Thanks very much! That works wonderfully well... Is this listed in the manual anywhere? because after two hours of reading, I didn't find it anywhere! None the less - thanks again. - Beau On 16/05/2008, at 11:56 PM, hubert depesz lubaczewski wrote: On Fri, May 16, 2008 at 11

Re: [SQL] Find all instances of a column in the entire database.

2008-05-16 Thread hubert depesz lubaczewski
On Fri, May 16, 2008 at 11:51:20PM +1000, Gavin 'Beau' Baumanis wrote: > I am hoping that you might be able to give me some assistance with the > following task! > I have a database with nearly 200 tables and I need to find all tables > that contain a column of myColumnName. select * from info