Re: Help! Script needed...

In article <58kmi5$ajf_at_news2.cais.com>, MCC <duffy_at_cais.cais.com> wrote:
> Does anyone have an working script that will list all the tables
>that have the same column names? For a particular column name, I need
>to know what tables have it. Instead of DESCRIB every tables in the
>database, a working script will be highly appreciated.

Try this:

Select Column_Name,Table_Name,Owner from All_Tab_Columns;

Or: Select Column_Name,Table_Name from User_Tab_Columns;

HTH,
Steve Cosner Received on Tue Dec 10 1996 - 00:00:00 CET