Re: Renaming a primary key

P B wrote:

> I have a set of table that look like this:
>
> One table with a P/N as a primary key and within some reference to
> other P/N
>
> One table with a P/N and a SPEC as a primary key (P/N referencing to
> the other table of course)
>
> And finally a bunch of other table referencing to the second table
> (P/N & SPEC)
>
> Question: How do I proceed to rename the primary key of the first
> table and cascade the change to all other table ?
>
> Thanks

Drop the foreign key.
Drop the primary key.
Create a new primary key.
Create a new foreign key.

Renaming is not an option.

Daniel Morgan Received on Fri Oct 11 2002 - 10:16:32 CDT