Re: change the primary key

"flora" <jadewind_at_tigtag.com> wrote in message news:3b9907d7_at_dnews.tpgi.com.au...
> in oracle7, using sql*plus, if i want to change the primary
> key how can i do that?

1. locate all the tables that have foreign keys pointing to the table that you want to modify, drop all those constraints.
2. drop the constraint on the table
3. drop the field
4. create the new field/fields
5. create the new constraint
6. create new FOREIGN KEYS for all the related tables.

Davide Received on Mon Sep 10 2001 - 04:12:26 CDT