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 -> change the primary key

change the primary key

From: flora <jadewind_at_tigtag.com>
Date: Sat, 8 Sep 2001 03:33:57 +0800
Message-ID: <3b9907d7@dnews.tpgi.com.au>


in oracle7, using sql*plus, if i want to change the primary key how can i do that? for example i have already created a table with primary key of "customer_name", and now i want to make "customer_id" the primary key. or i want to add a column named "customer_id" to be the primary key...

thanks~

--
Received on Fri Sep 07 2001 - 14:33:57 CDT

Original text of this message

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