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: changing primary key

Re: changing primary key

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 22 Oct 2002 13:23:35 -0500
Message-ID: <bq5bruc0i0eo4bc8jtn86na0234hn8hkhg@4ax.com>


Yes it does; AFAIK, it does it by dropping then recreating - Just what the OP did not want to do for some reason..

"Vitaliy Ogiychuk" <vitalio_at_infoplus.kiev.ua> wrote:

>"John" <jriker1_at_yahoo.com> wrote in message
>news:e6bb5a8d.0210181156.52569dff_at_posting.google.com...
>> In Oracle 8i 8.1.7, how do you go about changing the primary key from
>> one column to another without dropping it and recreating? Thanks.
>>
>> JR
>Use Embarcadero DBArtisan tool. It will do all by itself.
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Oct 22 2002 - 13:23:35 CDT

Original text of this message

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