Re: Searching a field

From: Gerry Solete <gm.solete_at_pacific.net.ph>
Date: Tue, 20 Feb 2001 23:09:12 +0800
Message-ID: <96u1su$r2q$1@nobel2.pacific.net.sg>

try this

select table_name
from user_tab_columns -- if the table is in your own schema where column_name = 'YOUR_COLUMN';

if you use that column name a lot, you'll get a lot on the list.

gerry

"Support" <suppot@_DO_NOT_SPAM_bilbao.com> wrote in message news:3a928153.713508531_at_news.sarenet.es...
> Hi!
>
> I've got the name of a field. I know it exists, but I do not know in
> wich table it is.
>
> Is there any good script to find it?
>
> Best regards...
>
> ============
> MIRELLO
Received on Tue Feb 20 2001 - 09:09:12 CST