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

Home -> Community -> Usenet -> c.d.o.misc -> Re: convert unique index to primary key

Re: convert unique index to primary key

From: damorgan <damorgan_at_exesolutions.com>
Date: Mon, 25 Mar 2002 16:32:30 GMT
Message-ID: <3C9F5128.BB0B5561@exesolutions.com>


Drop the unique index. Create the primary key.

Daniel Morgan

karolina wrote:

> Hi,
>
> I have some tables with unique indexes. I want to convert those unique
> indexes to primary keys. Does anybody have a script that runs through
> the tables and convert unique indexes to primary keys?
>
> thanks!
Received on Mon Mar 25 2002 - 10:32:30 CST

Original text of this message

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