Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the index name of the primary key ?
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