Re: Looking up tables that contain a column name

laredotornado_at_zipmail.com wrote:
> Hello,
>
> I'm using Oracle 9i on Solaris. Is it possible (and how) to look up
> all the tables that contain a column named "XX_COLUMN"? How would I do
> this?
>
> Thanks, - Dave

SELECT owner, table_name
FROM all_tab_columns
WHERE column_name = 'XX_COLUMN';

-- 
Daniel Morgan
Puget Sound Oracle Users Group