Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Querying for Unique or Primary Keys (analyze)

Querying for Unique or Primary Keys (analyze)

From: rtm <rtm_at_vulcansoft.com.au>
Date: Tue, 3 Aug 1999 17:10:47 +1000
Message-ID: <7o64k5$emc$1@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 - 02:10:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US