Re: Getting list of tables that have specified column?

In article <D8ry21.C65_at_freenet.carleton.ca>, Darren Mallette (ab454_at_FreeNet.Carleton.CA) writes:
>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
>

Hi Darren,
Try the view called USER_TAB_COLUMNS (Also DBA_TAB... and ALL_TAB...) It will have two columns COLUMN_NAME and TABLE_NAME, the combination should give you what you're looking for.

The view name might have been USER_TAB_COLS, no manuals handy, system not running.

Best I can do at short notice,

Regards,
Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
 ______________________/_____\__\_at_  @/___/_____\________________ 
|paladin.along.dialix.oz.au 					|
|Alex Long 		   					|		
|Adelaide, South Australia 					|
|_______________________________________________________________|
|Weep not for little Leonie,                   			|
|Abducted by a French Marquis!               			|
|Though loss of honour was a wrench,           			|
|Just think how it's improved her French.         Harry Graham. |
+_______________________________________________________________+
                   |    /\ /      \\       \ /\    |             
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '
                   
_