Renaming a primary key

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 Received on Fri Oct 11 2002 - 08:09:45 CDT