From owner-freebsd-questions Tue Jun 4 23:12:30 2002 Delivered-To: freebsd-questions@freebsd.org Received: from lexx.zssm.zp.ua (lexx.zssm.zp.ua [212.8.32.8]) by hub.freebsd.org (Postfix) with ESMTP id E616837B403 for ; Tue, 4 Jun 2002 23:12:22 -0700 (PDT) Received: from server.hermes-comp.zp.ua (germes-comp.zssm.zp.ua [212.8.32.132] (may be forged)) by lexx.zssm.zp.ua (8.9.2/8.9.2) with ESMTP id JAA11925; Wed, 5 Jun 2002 09:07:13 +0300 (EET DST) Received: from localhost (localhost [127.0.0.1]) by server.hermes-comp.zp.ua (8.11.3/8.11.3) with ESMTP id g5563Zq38540; Wed, 5 Jun 2002 09:03:54 +0300 (EEST) (envelope-from stalker@hermes-comp.zp.ua) Date: Wed, 5 Jun 2002 09:03:35 +0300 (EEST) From: Alexander V Zubchenko To: Eric Boucher Cc: FreeBSD Subject: Re: SQL question: how to find in all tables? In-Reply-To: <20020604172821.72740.qmail@web9402.mail.yahoo.com> Message-ID: <20020605085849.P38471-100000@server.hermes-comp.zp.ua> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Greetings! On Tue, 4 Jun 2002, Eric Boucher wrote: > Hi everyone, > > I have 2 questions for you guys regarding Sql (I have > to say that I'm a total newbie in that field). I have > search over the internet in some tutorials, but I > didn't found the answer: > > 1. > Is it possible to list every table that contains a > certain name in a column: for example, suppose that I > know that I have a couple of table which has a column > named "USERID", I want to have a list of all tables > that has this column in it. Because tables list and tables structure is internal data of RDBMS, this depend on which one You r using. In MySQL all this datas stored in mysql DB in different tables. In PostgreSQL i didn't find anything about topic. Mayb, i don't understand the situation, but in way of good design You need to know what tables You r using. > > 2. > Is it possible to list every table and column that has > an entry, for example, if I want to know the exact > tables and column where the word "toto" is listed. And this of course depend on answer on above question. > > If someone can also provide me a link to a good > tutorial if you found the information on the internet, > it will be appreciated. > > Thanks, > > Eric > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > So, may i ask you for more details? Always at your service, Alexander To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message