Add a column to the Primary Key?

[cjard]

Due to a design flaw i want to add a column to the primary key:

alter table myTable modify primary key pk_myTable(old_column1, old_column2, new_column)


oracle doesnt accept it? how can i change the pk without removing it, all the FKs that reference it and recreating them all again?

[slimdave]

you can't

[jmodic]

There is no other way but to drop the existing PK and create a new one with the additional column.

[cjard]

*cries*

[cjard]

okay, here's another related question.. what tool do you guys use to make your tables structure? im talking about something like maybe what Microsoft Access is to Jet.. what is like that for oracle?

i cant believe that everyone really sits down with toad/equiv and types

create table blah
add constraint xyz
...

[davey23uk]

some people use a design program which generates the code for them