Re: Getting list of tables that have specified column?
From: Ian Bainbridge <bainbridge_i_at_perc03_at_bgers.co.uk>
Date: 1995/05/18
Message-ID: <3pfoce$bib_at_atlas.bgers.co.uk>#1/1
Date: 1995/05/18
Message-ID: <3pfoce$bib_at_atlas.bgers.co.uk>#1/1
Darren,
Try
select table_name from user_tab_columns
where column_name = 'your_column';
or possibly you may need to use all_tab_columns and or dba_tab_columns depending upon your requirements and who owns the tables in question.
-- +--------------------------+-------------------------+-----------------------+Received on Thu May 18 1995 - 00:00:00 CEST
| Ian Bainbridge | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS | Newcastle Upon Tyne, UK | x2790 |
+--------------------------+-------------------------+-----------------------+