Re: change the primary key

flora wrote:
>
> 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...

1. alter table foo drop primary key;
2. create unique index foo_pk on foo(customer_id) tablespace . . . . ;
3. alter table foo add constraint foo_pk primary key (customer_id) using index;

-- 
Andrew Allen
E- Mailto:ajalle_at_ameritech.net