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...
>
> thanks~
>
> --

You must drop and recreate the constraint

hth
connor

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

http://www.oracledba.co.uk

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