Home » RDBMS Server » Server Administration » modify composite keys
modify composite keys [message #372355] Mon, 05 February 2001 08:04 Go to next message
Daniel Garcia
Messages: 1
Registered: February 2001
Junior Member
I have a table where the pk is a composite key on lets say (A, B). This table is referenced by foreign keys in other tables.
I am trying to change the order in the composite primary key so it references (B,A).
Any ideas as to what the best (or only) way to approach this task might be?

Many thanks in advance,

Dan

Report message to a moderator

Re: modify composite keys [message #372362 is a reply to message #372355] Mon, 05 February 2001 10:04 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
dron constraint and recreate..

Suresh

Report message to a moderator

Re: modify composite keys [message #372363 is a reply to message #372355] Mon, 05 February 2001 10:04 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
drop constraint and recreate..

Suresh

Report message to a moderator

Previous Topic: How to take spaces out on string
Next Topic: Passing a table (array) into a procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 00:55:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.