Date: Tue, 4 Jun 2002 10:28:21 -0700 (PDT) From: Eric Boucher <eric_boucher60@yahoo.com> To: FreeBSD <freebsd-questions@FreeBSD.ORG> Subject: SQL question: how to find in all tables? Message-ID: <20020604172821.72740.qmail@web9402.mail.yahoo.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020604172821.72740.qmail>