Re: Find all tables with a particular field

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 20 Sep 2006 20:43:00 GMT
Message-ID: <4511a461.13148015@news.hetnet.nl>

On Wed, 20 Sep 2006 11:05:29 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>Jaap W. van Dijk wrote:
>> On Mon, 18 Sep 2006 17:01:47 -0700, DA Morgan <damorgan_at_psoug.org>
>> wrote:
>>
>>
>>> The one you are looking for is: xxx_tab_columns.
>>> --
>>
>> This view gives the columns of all tables * and views *. The OP only
>> wanted columns of tables so he has to eliminate the views from this
>> view.
>>
>> Jaap.
>
>"so he has to eliminate the views from this view."
>
>We are not communicating well. I thought the OP wanted to know which
>objects contained a specific column name such as:
>
>SELECT table_name
>FROM user_tab_columns
>WHERE column_name = 'EMPID';
>--
>Daniel Morgan
>Puget Sound Oracle Users Group

Your SELECT will also find views (and clusters) with the column_name EMPID. I thought that the OP might not know this and I wanted to warn him, because he specifically asked for *tables* containing a column with a certain name.

Jaap. Received on Wed Sep 20 2006 - 15:43:00 CDT