Re: Querying for Unique or Primary Keys (analyze)

From: tmgn <tmgn_at_excite.com>
Date: Tue, 03 Aug 1999 10:45:13 -0400
Message-ID: <37A70079.11D26902@excite.com>

Did you try User_cons_columns,dba_cons_columns ?

-Thiru

rtm wrote:

> I am trying to write a script that generates analyze statements on the fly
> for all my tables at a column level. The columns I want to analyze are the
> primary and unique columns.
>
> I have found the constraints views and table views but i haven;'t been able
> to find a way of working out which columns are in primary or unique
> constraints.
>
> Any help greatly appreciated.
>
> cheers
> rtm
Received on Tue Aug 03 1999 - 09:45:13 CDT