Re: Searching a field

"Support" <support_at_PLEASE_DO_NOT_SPAM_bilbao.com> wrote in message news:3a9a8b92.1240419398_at_news.sarenet.es...
> Hi!
>
> Firstly, thanks to everybody who answered last post.
>
> I was looking for a script to find a table.
>
> I've got the name of a field. I know it exists, but I do not know in
> wich table it is.
>
> I tried with:
> SELECT table_name FROM user_tab_columns WHERE column_name='XXX'
> but I got 'no rows selected'.
>
> In fact, if I with
> SELECT column_name FROM user_tab_columns WHERE table_name='YYYY'
> I got the same message.
>
> Any help? Thank you in advance...
>
> ==========
> MIRELLO
user_tab_columns lists columns in tables that are owned by the particular user you are signed on as. Try all_tab_columns (I think that's what it's called - not sure) instead.

-Matt Received on Tue Feb 27 2001 - 05:23:40 CET