Re: Querying for Unique or Primary Keys (analyze)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 3 Aug 1999 09:05:10 +0100
Message-ID: <933669078.7584.2.nnrp-01.9e984b29@news.demon.co.uk>

Look at XXX_Cons_columns

XXX in DBA, USER, ALL

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

rtm wrote in message <7o64k5$emc$1_at_s3000-01.magna.com.au>...
>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 - 03:05:10 CDT