From owner-freebsd-questions Tue Jun 4 10:28:26 2002 Delivered-To: freebsd-questions@freebsd.org Received: from web9402.mail.yahoo.com (web9402.mail.yahoo.com [216.136.129.108]) by hub.freebsd.org (Postfix) with SMTP id A9DA537B406 for ; Tue, 4 Jun 2002 10:28:21 -0700 (PDT) Message-ID: <20020604172821.72740.qmail@web9402.mail.yahoo.com> Received: from [194.201.25.221] by web9402.mail.yahoo.com via HTTP; Tue, 04 Jun 2002 10:28:21 PDT Date: Tue, 4 Jun 2002 10:28:21 -0700 (PDT) From: Eric Boucher Subject: SQL question: how to find in all tables? To: FreeBSD 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 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. 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. 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