OraFAQ Forum: Server Utilities » Primary Key

Home » RDBMS Server » Server Utilities » Primary Key

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Primary Key [message #69443]

Tue, 08 January 2002 04:05

Cindy
Messages: 88
Registered: November 1999

Member

Hi all,

Does anyone know how to use the modify clause to modify the Primary Key constraint? A get around to this is to drop the primary key and then add it back to the table, but I'm curious why my modify clause does not work. Here is what I have tried:

Alter table JKL
MODIFY CONSTRAINT jkl_col1_pk PRIMARY KEY(jkl_col1, jkl_col2);

Thanks,
Cindy

Report message to a moderator

Re: Primary Key [message #69448 is a reply to message #69443]

Tue, 08 January 2002 10:24

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

you can use modify constraint clause only to change not null constraint, other constraints are not allowed to change using this clause.

Report message to a moderator

Re: Primary Key [message #71336 is a reply to message #69443]

Thu, 17 October 2002 02:19

san
Messages: 11
Registered: October 2001

Junior Member

Hey guys,
I'm also having the same problem.Do you have any idea.
Cheers,
San

Report message to a moderator

Previous Topic:	Effect of "CAT" scripts on other databases
Next Topic:	Data update problem AFTER Import/export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 07:44:45 CDT 2024