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 -> Re: How to get the index name of the primary key ?

Re: How to get the index name of the primary key ?

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: Fri, 27 Nov 1998 15:16:47 +0100
Message-ID: <73mcjk$9f5$1@cbu.pvtnet.cz>


Hi,
consult the USER_CONSTRAINTS, USER_CONS_COLUMNS and USER_IND_COLUMNS data dictionary views;

Hth,
Pavel

Bernhard Mandl wrote in message <73m9ad$m04$1_at_fleetstreet.Austria.EU.net>...
>Hello,
>
>I guess it must be in one of the system tables
>
>1.) if a table has a primary key defined and
>2.) if so, what's the index name of the primary key
>
>Does anyone know how to query this info ?
>
>thanks
>
>Bernhard
>
>
Received on Fri Nov 27 1998 - 08:16:47 CST

Original text of this message

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