Re: Getting list of tables that have specified column?

In article <D8ry21.C65_at_freenet.carleton.ca> ab454_at_FreeNet.Carleton.CA (Darren Mallette) writes:
>From: ab454_at_FreeNet.Carleton.CA (Darren Mallette)
>Subject: Getting list of tables that have specified column?
>Date: Thu, 18 May 1995 12:44:25 GMT
 

>Hello,
 

>I've been asked to update several columns in multiple tables in an Oracle 6
>database here at work. I was wondering if there is a way to get a list of
>tables that contain a specified column. Can this be done in SQL? If so, how?
 

>Thank you.
 

>-Darren
>--
>-Darren Mallette, computer guy
>Home page: http://www.magi.com/~dooley/index.html

Look at the view SYS.DBA_TAB_COLUMNS.

ex: select owner,table_name

    from sys.dba_tab_columns
    where column_name = '...';

Michel Lalonde. Received on Fri May 19 1995 - 00:00:00 CEST