Rename primary key [message #40656] |
Mon, 28 October 2002 09:01 |
Obede F. Souto
Messages: 5 Registered: June 2002
|
Junior Member |
|
|
Is it possible to rename primary key or drop it an create with another name in a table with data?
Oracle 8i (8.1.7)
|
|
|
|
Re: Rename primary key [message #40660 is a reply to message #40656] |
Mon, 28 October 2002 09:56 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
No, you can't rename a constraint in 8.1.7 - you can in 9i (R2?). Disable the foreign key constraints pointing to that PK and re-create the PK with the new name. Chances are that the underlying index belonging to the PK will be dropped in your case (it's not always true that it'll happen), so be sure to look at the existing storage paramaters of the index if you want it created with the same details. Re-enable the FK's
|
|
|