Re: convert unique index to primary key

damorgan wrote:
>
> 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!

Or don't even drop the index...the primary key will just grab it.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."